Forum Discussion
Combine two separate data flow to a new data flow
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), Datafl...
You need to append, not merge.
DF3 = DF1 & DF2
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?
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.
"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.