Forum Discussion

ahmedKalbani's avatar
ahmedKalbani
Frequent Visitor
7 years ago
Solved

Merging two dataset tables together and adding an identifier column

All,   I have two tables for two different projects (different source files) but they have the same header columns (but different row info). I want to add these two into one field and add a new col...
Tips and Tricks
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, ahmedKalbani

    Since the two tables have the same header columns, if you could use Append Function in Edit Queries?

    For example:

    table 1table 2

    Step1:

    Add  an identity custom column for each table

    Step2:

    Then click Home->Combine->Append Queries

    Result:

     

    Best Regards,

    Lin

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

 

From where should the Project Name be picked up?

ahmedKalbani's avatar
ahmedKalbani
Frequent Visitor
7 years ago
Im thinking doing an if condition based on the file name source