Good day! I have this test flow that I'm currently working. First source tile will provide the immediate inventories and the second tile will provide the future inventories. I was hoping that when I run the flow, that it will produce only one CSV file, but it didn't.
Is there any way to combine the output of the two sources into one CSV file? Any tip or work around is much appreciated. Thanks!
@raulbernales, since it may not be possible to combine the saved searches, which can often be the case for inventory searches given their complexity, you could create another flow. So flow 1 would be what you have now and there would be 2 files placed on the FTP server. You then could make a second flow that is triggered to run after the completion of flow 1. The second flow would be set to pick up the files that were placed and then will create a single file. On flow 1, I would place the files into a staging directory, then flow 2 picks from the staging directory and places in final directory.
@raulbernales it looks like you have parse file set to false on the source/export. Can you remake it and set to yes I want to parse the files? Your parsing strategy may be different. You even may just make the file type JSON when you temp store in staging, then convert to CSV on the FTP import step on flow 2.
@tylerlamparter I followed your instructions and was successful this time. The json files were merged into one CSV file. Below is the screenshot and the numbers under the run console were the expected numbers.