This content has been marked as final.
Show 2 replies
-
1. Re: Unique comma seprataed values instead of cloumn wise
swaroop.gantela Nov 16, 2018 6:36 PM (in response to nilesh.patil.2)Nilesh,
I think you can accomplish the first part using:
WINDOW_MAX([Calculation1])
which can then be used in further CONTAIN type calculated fields.
Using the conditional will help you for the second part:
IF FIRST()=0 THEN ATTR([Roles])
ELSEIF NOT(CONTAINS(PREVIOUS_VALUE(""),ATTR([Roles])))
THEN PREVIOUS_VALUE("")+", "+ATTR([Roles])
ELSE PREVIOUS_VALUE("")
END
Please see workbook v10.3 attached in the Forum Thread:
Unique comma seprataed values instead of cloumn wise
-
287909running_v10.3.twbx 26.4 KB
-
-
2. Re: Unique comma seprataed values instead of cloumn wise
nilesh.patil.2 Nov 19, 2018 10:57 AM (in response to swaroop.gantela)Swaroop, Thank you so much for your time on this.