Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

2022-05-24 Updates: Login: If you are facing issues with logging in, please try clearing all your cookies or trying another browser. We have a fix being deployed on the evening of 5/25. Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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