Filtering a list of REF_ROWS() to unique values of a non-ID column

[Flavia]

Hi! I have a table A, which references a slice of another table B.

Table B (slice) has columns: [ID], [Ref to table C], [some number]. That number is the same for each [C]. 

What I need is for the inline view in the detail A to display:

[C1] [corresponding number]

[C2] [corresponding number]

...

Since the number is the same for each [C], I get multiple identical entries, since these rows have different IDs, but the rest of the information is the same. How do I filter this data to leave only unique [C][number] values in  the inline view?

Thanks in advance!

[Joseph_Seddik]

Welcome to the community!

To make it easier for the community member to help you, please post screenshots of your actual table and slices columns and clearly show the references between them. Some info of your description is not consistent. Thank you. 

[Marc_Dillon · Accepted solution]

I'd suggest that you need to add another Table, which holds all unique record of the "C"s, and their "numbers".

But without that, to directly answer your question, you just need your Slice to only have a single record for each "C". You can do that with an expression comparing the key value with the result of a MINROW or MAXROW. Something like:

[_THISROW] = MINROW( table , _RowNumber , [C] = [_THISROW].[C] )

https://help.appsheet.com/en/articles/2357311-minrow

https://help.appsheet.com/en/articles/2357310-maxrow