Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
If I have a table
Temp:
Load * inline[
A B
A1 B1
A1 B2
A2 B2
A2 B1
]
Can I store all value of B into another variable if corresponding A = A1 without using data editor? Using create variable in Analysis?
Since I want to just use the variable to create default bookmark
Try your variable definition as:
Concat(Distinct {<A={'A1'}>}, B , ',')
I don't want concat since I want to show in separated item in the table
Do you mean, if there are multiple possible values in B field - you would want them in multiple variables...?
you can achieve this in script editor