Copying data from one flow chain into another flow chain for processing

Hi.

I have two flow chains. One input a file and do some data manipulation with. Another contains header data that I used the report header tool to bring in.

How do I copy values from one or more columns in the first chain into a column in the another chain to populate that table so I can further do additional data processing on?

Workflow

Accepted answers

atcodedog05

Hi @KNguyen

Append tool work like a cross join of combination tool. Refer below.

It always creates more rows and columns. Refer to the attached workflow.

Also on your main workflow can you provide some sample input files and expected output files It will help us get a better understanding of the usecase.

We will be happy to help : )

append logic.yxmd

All comments

binu_acs

@KNguyen the append tool would be an option here

KNguyen

Thanks. I'll give that a try. As I was typing the last post and after pressing submit, I tried the long way was to do a union and then use the formula tool to copy the data over. I'll see if append is better.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703