Append the mapped(join) results at the end of each row
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
New to Alteryx, I Have a table A
Input:
ID | Name | Lvl1 | NAME1 | LVL2 | NAME2 | LVL3 | NAME3 | LVL4 | NAME4 | LVL5 | NAME5 | LVL6 | NAME6 | LVL7 | NAME7 | LVL8 | NAME8 | LVL9 | NAME9 | LVL10 | NAME10 |
ID1 | TEST1 | 1234567 | MYNAME | 78906 | MYNAME2 | 67459 | MYNAME3 | ||||||||||||||
ID2 | TEST2 | 1234567 | MYNAME | 5678 | MYNAME28 | ||||||||||||||||
ID3 | TEST3 | 1234567 | MYNAME | 89065 | MYNAME89 | 890765 | IAMNEW789 | 764536 | IAMTERNDING | 123456 | |||||||||||
ID4 | TEST4 | 1234568 | IAMNEW | 89765 | IAMNEW45 | 34567 | IAMNEW789 |
I have a Table B similar to the one below
TABLE B
ID | Name | MGR_ID | MG_NAME |
ID1 | TEST1 | 67895 | MYNAME |
ID2 | TEST2 | 78906 | NEWNAME2 |
ID3 | TEST3 | 13456 | NEWHERE3 |
ID4 | TEST4 | 187254 | MYNAME78 |
My result output should have the MGR_ID and MG_NAME added to the empty values at the end.
ID | Name | Lvl1 | NAME1 | LVL2 | NAME2 | LVL3 | NAME3 | LVL4 | NAME4 | LVL5 | NAME5 | LVL6 | NAME6 | LVL7 | NAME7 | LVL8 | NAME8 | LVL9 | NAME9 | LVL10 | NAME10 |
ID1 | TEST1 | 1234567 | MYNAME | 78906 | MYNAME2 | 67459 | MYNAME3 | 67895 | MYNAME | ||||||||||||
ID2 | TEST2 | 1234567 | MYNAME | 5678 | MYNAME28 | 78906 | NEWNAME2 | ||||||||||||||
ID3 | TEST3 | 1234567 | MYNAME | 89065 | MYNAME89 | 890765 | IAMNEW789 | 764536 | IAMTERNDING | 13456 | NEWHERE3 | 123456 | |||||||||
ID4 | TEST4 | 1234568 | IAMNEW | 89765 | IAMNEW45 | 34567 | IAMNEW789 | 187254 | MYNAME78 |
Thanks,
Bharat
Solved! Go to Solution.
- Labels:
- Developer
- Dynamic Processing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You should be able to connect your Input to the L on a join tool, and connect Table B to the R on the join tool. Then configure it to join on the ID field in the configuration window. This should link up the data as you are requesting.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It should look something like this
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@bharatm Attached is the workflow that gives you your results. You have to pivot the data using the transform tools and then add logic to create the lvl and name and pivot it back. Hope this helps.
Alteryx
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @bharatm,
How about the Attached Macro?
As seen in the attached Workflow I have taken the sample data you have mentioned and achieved the requested Result using a batch Macro where operation is done record by record.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DiganP - Thanks a ton. That was really helpful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @Manjunath, As I am new to Alteryx- I have not explored the concept of Macros yet. I am in the process of learning them.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@bharatm Happy to help! You can directly use the macro attached for your purpose. You only have to add in a record ID Tool before adding the macro in your workflow, You can use the screenshot as a reference for configuration.
Let me know if you need more info!
