Merge data and use the output to run workflow in the same designer workflow

Question

Hi, I have a data (data A) which I get on a regular basis.

I am merging data A with the master data file which consists of past data which becomes data B.

I would like to use data B (the merged data) to run the workflow in the same designer.

In the image below, I have attempted this but it doesn't work as intended because the file will start processing before the data B is compiled with the latest data.

Is there any other way to do it within a single workflow? Thank you!

Christina_H · Answer

Maybe neither of us is phrasing it well.  I understand that both of your B inputs are pulling in 'pre-B' data, but 'new-B' data is coming out of the union.

kv-defy · Answer

Thanks @Christina_H I might not have phrase it nicely. When I merge A and pre B (which is the master file) I will obtain data B. I want to use data B to do a series of workflows in the bottom workflow before getting the final output. However, I cant do it this way because it will read the input file from the 2nd workflow in the bottom first which is not the final version of the consolidated data.

Christina_H · Answer

If I understand this correctly, you don't need to read data B back in from the data file.  You've just written the data, so it's already in your workflow.  Just do your next lot of processing using the data from your union.