Free Trial

Alteryx Designer Desktop Discussions

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

Add data to two columns only

Baz123
8 - Asteroid

Hi,

I have a workflow that is producing a table with about 14 columns. Basic HR type data Name, Email, phone etc.

 

There is another list that I have from another input which only has the persons name and email.

 

How can I merge these handful of names onto the end of the existing report - minus all other row data? The other column data will be 'Null" which is fine, I just need these extra ppl added to the end of the existing workflow.

 

So far I have tried to use a 'Selet records' tool to take the workflow, clean all data except the headers then join the name columns to create the report with the new data only then merge all back together.

 

Nothing so far seems to work...

 

Thanks.

1 REPLY 1
aatalai
14 - Magnetar

look at the join/find and replace tool for joining

Labels
Top Solution Authors