We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
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
Start Free Trial

Alteryx Designer Desktop Discussions

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

Sort

Amit_Rastogi
7 - Meteor
‎07-09-2020 11:05 AM

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
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
Aaron_Harter
11 - Bolide
‎07-09-2020 11:13 AM

Hi @Amit_Rastogi, 

 

Check out the attached solution:

1.PNG 

2020-07-09 1.yxmd
Reply
0 Likes
Amit_Rastogi
7 - Meteor
‎07-09-2020 11:44 AM

Thank you.. works perfect for me..

Reply
Live Office Hours
Labels
Top Solution Authors
View All