Vlookup data from ALteryx output to an excel template

Question

Hello All;

Hope you are staying safe and healthy.

I am trying to join an Alteryx output to an Excel Template. not all the rows and columns in the template has to be in the Alteryx output. I want to v-lookup if there is a value then should be linked to the Excel template.

Here is the Alteryx output

And below is a screen shot of the Excel template

Please be noted that there are rows and columns are just summing other rows or columns respectively

Please advise.

Thank you so much!

grossal · Accepted Answer

Hi @Danero,

I think you could use the Join Multiple Tool for this.

It will join the data if the key exists and leave the rest untouched.

Best

Alex