Forum Discussion

anna93's avatar
anna93
Regular Visitor
6 years ago
Solved

Combine / Append tables based on condition

Hello all,    I am trying to combine / append two tables with the same columns only if condition is met. For example, from table 1 below I would to like to get the rows in which Project Number = PO...
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    Hi anna93 

    Create a new query and uncheck "enable load",

    Then in Table2, append query1

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi anna93 

Is the table1 the same with table2?

 

Best Regards

Maggie

anna93's avatar
anna93
Regular Visitor
6 years ago

Hi Maggie, 

 

Yes both tables have same column names, it just have different data.