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?
Solved! Go to Solution.
@KNguyen the append tool would be an option here
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.
Hi @KNguyen
Just curious to know what is the intended goal and output since you are using the header. Maybe we can help you better 🙂
I have a template file I need to populate that contains just the header. I can use the output and then select that template file to map it that way. But I have some fields needing to be static and some needing to be fed from the first chain flow. So I wanted to import in the header so I can create a table for me to then do the necessary changes, then create an output to populate that template file.
Hi @KNguyen
Just to shed some clarity header tool doesn't read the header from the file the header tool config is static and can create headers in only specific ways.
Output: Attach a header tool to see how the report looks like.
Another option is to select image but it will be statically set
Hope this is helpful. If I am missing a point or understanding your use-case incorrectly let me know.
Thanks for the insight. I guess I am using the header tool in the non-intended way, but it does read the excel file header row (row #1) and allowed me use the select tool to bring that in as a column header. I've tried the append method and union method. Both yield same result as well.
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 : )
Happy to help : ) @KNguyen
Cheers and have a nice day!
Hi @KNguyen
If you need help with the actual usecase let me know and share me the files.
Happy to help : )