Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi try this
For distinct
=Concat(DISTINCT P( [$Field] ), ', ', 10)
Then create a variable
=$(vSelectedField)
Then
=Concat(DISTINCT $(vSelectedField), ', ') to display values or metrics.