Combine two separate data flow to a new data flow

[amirghaderi]

Is there anyway to combine data from two separate data flow (exactly the same structure) into one data flow.

graphical view as below. Dataflow1 (data for the West), dataflow2 (Data for East), Dataflow3 (Data for combined East/West). I tried to use the Linked dataflow function, however, it still creates table1 and table2 separately in dataflow3

[lbendlin]

You need to append, not merge.

DF3 = DF1 & DF2

[amirghaderi]

to append, I should bring table 1/2 from data flow 1/2 to data flow 3 and then append in data flow 3, meaning it will end up having data flow 3 with unnecessary table1/2 data. how to append at start without bringing table 1/2 to data flow 3 as standalone tables first?

[lbendlin]

you mean "wash me but don't make me wet" ?  The data has to travel at some point. You can't avoid that.

You can choose not to load tables 1 and 2 for the final result but you cannot avoid having to fetch them.

[amirghaderi]

"You can have dry wash and not to get wet". I was looking for a way to use linked data flow function without recreating the whole original data.