Forum Discussion

Mary_789's avatar
Mary_789
Frequent Visitor
4 years ago
Solved

Adding new columns from another table based on conditions

Hello,   I have two sets of data that is being imported in from two different sources. Dataset#1 contains the following columns (and additional columns not needed to match) : Brand, Vehicle, Type, ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Mary_789 ;

    You could merge it by Multiple columns.

    Expand it.

    The final output is shown below:

    Or can you share the example data and the result you want to output?


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

johnt75's avatar
johnt75
Icon for Super User rankSuper User
4 years ago

Maybe I was thinking of Append Queries then. There's definitely a way to join 2 tables on common columns, and I'm sure its either Merge or Append

Mary_789's avatar
Mary_789
Frequent Visitor
4 years ago

johnt75 Yup I am able to join the tables by appending the data.

The problem is now that there are duplicate rows, one with status type and status column with values and another with status type and status column with null as the value. 

I want to be able to combine those rows into one.