Forum Discussion

amirghaderi's avatar
amirghaderi
Helper IV
2 years ago

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), Dataflow3 (Data for combined East/West). I tried to use the Linked dataflow function, however, it still creates table1 and table2 separately in dataflow3

 

 

Need Help

4 Replies

    • amirghaderi's avatar
      amirghaderi
      Helper IV
      2 years ago
      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's avatar
        lbendlin
        Super User
        2 years ago

        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.