Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Andy Uttley, Alteryx ACE, makes music with Alteryx | Math + Music
SOLVED

UNIQUE WORD in each row.

Highlighted
7 - Meteor

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

Highlighted
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

Highlighted
7 - Meteor

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

 

Capture.PNG

Highlighted
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

Highlighted
7 - Meteor

Thanks @CKP 
I really appreciate your help with this.

Labels