Hi Members,
I have an requirement of identifying unique values of customer in each department. Please see below module which is have a dimension of departments list with three list items(D1,D,2,D3) and a line item(Customer Names) which is having concatenated names of all customers in each department with delimiter as ",". I want to remove duplicate names in each department and produce an output of unique names in each department in a sperate line item(Unique Customer Names). Please see sample data arranged in below table.
Department | D1 | D2 | D3 |
L1:Customer Names(Text) | ABC,XYZ,ABC | ABC,XYZ | PQR,PQR |
L2: Unique Customer Names(Text) | ABC,XYZ | ABC,XYZ | PQR |
Thanks,
Suman.