Forum Discussion

amirghaderi's avatar
amirghaderi
Icon for Helper IV rankHelper 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), Datafl...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You need to append, not merge.

 

DF3 = DF1 & DF2

  • amirghaderi's avatar
    amirghaderi
    Icon for Helper IV rankHelper 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
      Icon for Super User rankSuper 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.

      • amirghaderi's avatar
        amirghaderi
        Icon for Helper IV rankHelper IV
        2 years ago

        "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.