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

[KNguyen]

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?

[KNguyen]

Hi...

Sorry, was away from the keyboard when I did that. Here is a sample use case. 

Excel File #1

Col A	Col B	Col C	Col D
Joe	0000123	20220101	California
Smith	0000456	20211001	Texas

Excel File #2 - Template File, Contains only header row. 

Name

ID

Date

Zip Code

City

Favorite Food

Static Value

State

End Result

Name	ID	Date	Zip code	City	Favorite Food	Static Value	State
Joe	123	01/01/2022				Purple	California
Smith	456	10/02/2021				Purple	Texas

[atcodedog05]

Hi @KNguyen 

Here is how you can do it.

Workflow:

Hope this helps : )