Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Append the mapped(join) results at the end of each row

bharatm
6 - Meteoroid

Hi,

New to Alteryx, I Have a table A 

 

Input:

IDNameLvl1NAME1LVL2NAME2LVL3 NAME3LVL4 NAME4LVL5NAME5LVL6NAME6LVL7NAME7LVL8NAME8LVL9NAME9LVL10NAME10
ID1TEST11234567MYNAME78906MYNAME267459MYNAME3              
ID2TEST21234567MYNAME5678MYNAME28                
ID3TEST31234567MYNAME89065MYNAME89890765IAMNEW789764536IAMTERNDING           123456
ID4TEST41234568IAMNEW89765IAMNEW4534567IAMNEW789              

 

I have a Table B similar to the one below

 

TABLE B

IDNameMGR_IDMG_NAME
ID1TEST167895MYNAME
ID2TEST278906NEWNAME2
ID3TEST313456NEWHERE3
ID4TEST4187254MYNAME78

 

 

My result output should have the MGR_ID and MG_NAME added to the empty values at the end.

 

IDNameLvl1NAME1LVL2NAME2LVL3 NAME3LVL4 NAME4LVL5NAME5LVL6NAME6LVL7NAME7LVL8NAME8LVL9NAME9LVL10NAME10
ID1TEST11234567MYNAME78906MYNAME267459MYNAME367895MYNAME            
ID2TEST21234567MYNAME5678MYNAME2878906NEWNAME2              
ID3TEST31234567MYNAME89065MYNAME89890765IAMNEW789764536IAMTERNDING13456NEWHERE3         123456
ID4TEST41234568IAMNEW89765IAMNEW4534567IAMNEW789187254MYNAME78            

 

 

Thanks,

Bharat

7 REPLIES 7
BrandonB
Alteryx
Alteryx

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. 

BrandonB
Alteryx
Alteryx

It should look something like this

 

join.png

DiganP
Alteryx Alumni (Retired)

@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.

Capture.PNG

 

Digan
Alteryx
Manjunath
8 - Asteroid

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.

 

Batch Macro.PNGMacro Config.PNG

 

 

bharatm
6 - Meteoroid

@DiganP - Thanks a ton. That was really helpful.

bharatm
6 - Meteoroid

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.

Manjunath
8 - Asteroid

@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!

Labels