Hello,
I have a comparison between two sheets containing grocery items in the last month and this month.
The columns are -
Name
Type
Rate
Quantity
The requirement is to know -
1. If there are any items that are added in this month list, it should be marked as "Added" in a new column in the final output.
2. If there are any items that are updated for example, a change in rate or quantity, it should be marked as "Updated" in the column.
3. If there are any items that are removed in the previous month, it should be marked as "Deleted".
4. If there is no change in the item in this month list, it should be marked as "No Change"
Example
May -
Name | Type | Price | Quantity |
Item A | Kitchen | 10 | 1 |
Item B | Toiletries | 30 | 3 |
Item C | Garage | 40 | 4 |
June -
Name | Type | Price | Quantity |
Item A | Kitchen | 10 | 1 |
Item B | Toiletries | 35 | 3 |
Item D | Garden | 40 | 4 |
The output should be
Name | Type | Price | Quantity | Action |
Item A | Kitchen | 10 | 1 | No Change |
Item B | Toiletries | 40 | 3 | Updated |
Item C | Garage | 40 | 4 | Deleted |
Item D | Garden | 40 | 4 | Added |
I tried to achieve it through outer join between this month and last month but I was not able to find a way to add the action column in my final output.
Any pointers would be helpful. Thanks!!
Solved! Go to Solution.
Hi Nikhil,
The only change made to the workflow to address the issue with duplicates was the change in the join keys.
Please Use Name and Type both as your join keys and you will get the desired results.
I hope this solves your issue