Alteryx Designer Desktop Discussions

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

Updating Join Tool Using Batch Macro

nickgomez610
7 - Meteor

Hello everyone,

 

I have created a batch macro and would like to figure out how to dynamically update the join. Furthermore, each row in my control parameter vector has a list of the different columns I would like to base my join on ex: Record 1=(x,y,z) and I would like to join on columns x, y, and z. Let me know if this makes sense and or if it is possible! 

 

Thanks,

Nick

2 REPLIES 2
AbhilashR
15 - Aurora
15 - Aurora

Hi @nickgomez610, would you be able to share your workflow for us to look at? It'll help us better understand your setup and help figure out a solution. 

KaneG
Alteryx Alumni (Retired)

An easy way to do this often is to transpose the fields and then join on name and value as then the field names will be data in the Name column.

 

Labels