Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Complex Join

Hi All,   I have a list of current subscribers for every week for the past year (inlcudes customer ID) that I have appended into one table and included a column 'Report Date'. I want to create 2 ad...
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    1 year ago

    Hi Anonymous 

    I've mocked up your data and created 3 tables.

    The first is filtered to this week and the other two are filtered to last week.

     

    On the In last week I have used a merge to the original table on the customer ID and set it to inner join (only rows in both tables)

     

    For the Not in last week do the same thing but change the join to Left Anti (Rows in this table NOT in the other table).

     

SamWiseOwl's avatar
SamWiseOwl
Icon for Super User rankSuper User
1 year ago

Hi Anonymous 

I've mocked up your data and created 3 tables.

The first is filtered to this week and the other two are filtered to last week.

 

On the In last week I have used a merge to the original table on the customer ID and set it to inner join (only rows in both tables)

 

For the Not in last week do the same thing but change the join to Left Anti (Rows in this table NOT in the other table).