Excel Data comparison

[prasann]

Hello All,

how to compare excel data week over week, if the data got added or deleted or modified when comparing two excel sheets data based on date field. how can we resolve this issue.

Regards,

Prasanna

[summarizer]

There are a few different ways and without knowing more about your issue, you could use the JOIN tool to join the two sheets by the date column and see what doesn't match up - meaning you can see what was added or deleted or modified.

[prasann]

@summarizer

Thanks for your quick reply

On weekly basis i will get the new two excel data here is challenge i got, based on data week over week i have to give the what was added or deleted or modified. Any suggestions please.

Rregards,

Prananna

[summarizer]

This is a very rudimentary example.  You can make it more robust and automate it as you need.

Use the JOIN tool and see what comes out.  In this case, the bottom right is showing what doesn't match from the first week.

[prasann]

@ summarizer

wow i got it now, now i need to build the derived field based on addition or deletion.

if added this week 'Y if not i have to show 'N' same way for delete metric as well. Kindly help me 

[summarizer · Accepted solution]

@prasann  As I say, there are surely other ways to do this - like even with the Summarize tool potentially, but this is just really basic.  You may find a better way from another suggestion.

This is the basic workflow behind this.

[prasann]

summarizer

Thanks a lot for your help