Need to remove duplicated text values from a text Line Item

Options
Suman Reddy
Suman Reddy Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Frequent Contributor
in Planning & Modeling

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. 

 

DepartmentD1D2D3
L1:Customer Names(Text)ABC,XYZ,ABCABC,XYZPQR,PQR
L2: Unique Customer Names(Text)ABC,XYZABC,XYZPQR

 

 

Thanks,

Suman.

Tagged:

Comments

  • Suman Reddy
    Suman Reddy Member, ALL USERS, Community Member, Certified Model Builder Posts: 5 Frequent Contributor

    Thanks Kirill for your response.

     

    I have customer name as another list, In reality I have already three lists as dimensions for line item 1: Customer Name. If i bring in customer name list  as fourth dimension into new line item or module then it is causing maximum size limit of a line item 2 billion cells. Let me see how can i reduce my line item size. 

    I would appreciate if you have  any other solution with the same existing dimensions on line item 1.

     

    Thanks,

    Suman.

     

     

Categories