Comparison

[Nikkhil]

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!!

[grazitti_sapna · Accepted 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