UNIQUE WORD in each row.

[iamviraj13]

Hi All,

I need help in removing duplicates and selecting only unique words from each row.

I am able to do it for limited rows, but what if I have 25-30k rows.

I have attached the input which needs to be worked on and an example of what exactly I am looking for. Thanks in Advance.

 

[CKP · Accepted solution]

Hi @iamviraj13 

I don't think I've found exactly what you're looking for but I think this is close.

Let me know if it helps

[iamviraj13 · Accepted solution]

Figured out. Thanks. But would accept a more optimized solution.

 

[CKP]

Hey @iamviraj13 

A huge improvement to my attempt! The only optimisation I can see is if you change the selection in the Unique tool from 'RecordID' to 'Item' then you can remove the first 2 tools as below.

[iamviraj13]

Thanks @CKP 
I really appreciate your help with this.