Forum Discussion

chris-thompson's avatar
chris-thompson
Helper I
4 years ago
Solved

How to Append Tables Based on a Condition

Hi there:   I have 2 tables containing participants for multiple events that we have hosted.  One table contains specific session by session attendance by individual ONLY for events that have multi...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    I have performed one Right Anti join. This join removed the matching rows from second table.

    Removed all columns and expanded the table.

    Now, I have a table which is having common rows removed from second table.

    Appended this result to Output of Changed Type which was our original table.

    Replace null in Session with Single-session.

chris-thompson's avatar
chris-thompson
Helper I
4 years ago

Can you explain the steps of what you did?  I'm trying to learn what you did so I can apply it to the real data scenario I am dealing with.

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

I have performed one Right Anti join. This join removed the matching rows from second table.

Removed all columns and expanded the table.

Now, I have a table which is having common rows removed from second table.

Appended this result to Output of Changed Type which was our original table.

Replace null in Session with Single-session.