Alteryx Designer Desktop Discussions

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

Column data manipulation

EvansM
9 - Comet

Hello Community,

 

I need help with manipulating data.  Please see the attached SAMPLE data and EXPECTED RESULTS spreadsheets.  For the accounts with the same Account Numbers, but have a SubType ID of '6',  add a '6' before the account number. Therefore 6+Account Number. (Please see the EXPECTED RESULTS spreadsheet).

Thanks. 

 

 

sample data 

EvansM_1-1648682607883.png

 

 

expected results 

EvansM_0-1648682555156.png

 

5 REPLIES 5
Qiu
20 - Arcturus
20 - Arcturus

@EvansM 
I hope this would work.

0331-EvansM.PNG

Tyro_abc
11 - Bolide

Hi @EvansM 

 

This is my version, let me know if you have any questions.

Tyro_abc_0-1648687499696.png

 

Regards

Arundhuti

EvansM
9 - Comet

@Tyro_abc Thanks a lot

 

EvansM
9 - Comet

@Qiu Thanks. I think this is going to work.

 

Qiu
20 - Arcturus
20 - Arcturus

@EvansM 
Thank you for the feedback😁

Labels