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.
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.
It should look something like this
@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.
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.
@DiganP - Thanks a ton. That was really helpful.
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.
@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!