Forum Discussion

Liam01's avatar
Liam01
Helper I
2 years ago

Combine multiple sheets with the same table but with different columns

Hello all,   I'm trying to create a Dataflow to combine multiple Excel spreadsheets where there is a defined table - InputSheet - but the number of columns and the order of the columns is different...
Need Help
dufoq3's avatar
dufoq3
Community Champion
2 years ago

Hi Liam01,
Sheet1 (Table1)

 

Sheet2 (Table2) - different column order and 1 additional column (Salary)

 

Result

 

You can download excel file here.

 

  • Liam01's avatar
    Liam01
    Helper I
    2 years ago

    Thanks. I'm not sure what the sheet is meant to be showing - I can only see Table 1 and Table 2 on it? And it won't let me open in the app