Alteryx Designer Desktop Discussions

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

Sort

Amit_Rastogi
7 - Meteor

I have Input file 1 with data

IDName
1Car
2Bike
3Cycle

 

Input 2

ID2Name2
1Sum
2Count
3Group

 

want Output look like this

IDName
01Car
0101sum
0102count
0103group
02Bike
0201Sum
0202Count
0203Group
03Cycle
0301Sum
0302count
0303Group
2 REPLIES 2
Aaron_Harter
11 - Bolide

Hi @Amit_Rastogi

 

Check out the attached solution:

1.PNG 

Amit_Rastogi
7 - Meteor

Thank you.. works perfect for me..

Labels