Append Fields workflow

[AntlRo]

Good Morning,

I have a fake payroll Append that I would like to append additional rows to each name that are not available in the main file called example1.png. I want the output to look like the output attached (output1.png) and the current file looks like the one attached called "example1".  I have attached the image of my workflow as for some reason I couldnt post.  I was trying to get to work but I cant get all the rows lodaded like output 1. Please keep in mind the "real"  file and the real ending  output has thousands rows in my fake payroll department.

Please post your solution workflow ,  would be greatly appreciated. 

[binuacs]

@AntlRo I updated the macro to be dynamic, you need to provide the list task  names in a separate excel file which will feed to macro

[Felipe_Ribeir0 · Accepted solution]

Hi @AntlRo 

Please check this updated version. Now you will be adding every different task that happens to show on the dataset to be considered!

[AntlRo]

Thanks I tested this and it works on my end