Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Data transformation

howyoudoing
8 - Asteroid
‎10-16-2024 06:51 AM

Hi All,

 

I have the data attached and would like to have the data as this format - '549300GNB8SC2JEHDW74','549300TECZFP4RC3RN89','...' without duplicates. Are you able to help?

salesnumber.yxmd
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
JosephSerpis
17 - Castor
17 - Castor
‎10-16-2024 06:59 AM

Hi @howyoudoing I think you are asking to concatenate your data without duplicates which you can do with a unique tool and summarise tool.

 

Screenshot 2024-10-16 145959.png

salesnumber.yxmd
Reply
register for inspire
designer new user guide
Labels
Top Solution Authors
View All