Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

UNIQUE WORD in each row.

iamviraj13
8 - Asteroid

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.

 

Capture.PNG

4 REPLIES 4
CKP
10 - Fireball

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
8 - Asteroid

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

 

Capture.PNG

CKP
10 - Fireball

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.

 

No Repeating Words.jpg

iamviraj13
8 - Asteroid

Thanks @CKP 
I really appreciate your help with this.

Labels