Show value list for the fields

[Amit_B]

Hi everyone,

I have a table that contain the names of all the tables in the model ($Table) and all the fields in the model ($Field).

I need to do the following:
1. Add a column that shows 5-10 sample distinct values for each field.
2. When a field is selected (from $Field column), I want to display a list of all distinct values that exist in that field, shown in a separate object (in table for example).

Is there a way to achieve this?

Thanks!

[Chanty4u · Accepted solution]

Hi try this 

For distinct 

=Concat(DISTINCT P( [$Field] ), ', ', 10)

Then create a variable 

=$(vSelectedField)

Then 

=Concat(DISTINCT $(vSelectedField), ', ') to display values or metrics.