Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
in a table object I want to show exactly one of multiple possible values.
The dimension is KN_ID.
One KN_ID can have multiple OB_ID and therefore multiple values for OB_Type. In the Table I want to show OB_Type as a measure but I do not want to do any aggregation. I just want the column OB_Type to show one of the possible values for OB_Type for KN_ID.
So far I tried achieving that by using concat and other string functions, but I could not find a satisfying solution.
Could somebody help me with that?
Example is attached
Best regards and thanks in advance
thorben
For some reason subfield(MaxString(rand()&'|'&OB_Type),'|',2) is empty sometimes. OB_Type does contain empty strings. Maybe it has to do with the rand()-function or with the null-values contained by OB_Type...
Ah..ok, then something like this
subfield(MaxString(len(OB_Type)&'|'&rand()&'|'&OB_Type),'|',3)
to ensure that strings with non-null values come up on top.
thank you very much
What an overhead to do such a simple thing
Your welcome!
That's true!