Append Fields workflow

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.

Workflow

Datasets

Tips and Tricks

Custom Tools

Accepted answers

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

Append Fields workflow.yxmd

All comments

@AntlRo would you be able to share the outputs / workflow?

One way of doing this, i think that it will not be a problem to run this workflow with this amount of rows. (UPDATED*)

Append Fields workflow.yxmd

I posted screen shots as for some reason I couldnt post my dummy data.

Hello @AntlRo ,

not sure if this is what you are looking for, can you check my example and tell me if I did understand it correctly?

Regards

Solution_union_data.yxmd

Please take a look at the attached workflow (updated version).

Append Fields workflow.yxmd

do you mind posting the as a .yxmd? for some reason I'm having issues downloading on my personal pc.

@AntlRo One way of doing this with the batch macro

Append_Field_Workflow_1107.yxzp

here is the yxmd

Append Fields workflow.yxmd

This is great! Thanks

, now what happends if the 4 source rows changes and a new database has 2-3 more rows for that source rows, how would you change to to anticipate potential new fields ?

The below is what you have :

Task

1.eat

2. sleep

3. walk

4. run

To take a last step further how would you change that source to be open to whatever new tasks come in whether you know the name of the task or not ( example below)

Task

1.eat

2. sleep

3. walk

4. run

5. crawl -- new row

6. push -- new row

7. ??? -- new row that we wont know unless the workflow will know to add it

8. ??? -- same as above, unknown row but needs to be open to accept unknown tasks

@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

Append_Field_Workflow_1107.yxzp

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

Append Fields workflow.yxmd

Thanks I tested this and it works on my end

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703