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.
look at the join/find and replace tool for joining