Forum Discussion
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...
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).
ryan_mayu
Super User
Super Usercould you pls provide some sample data and expected output?