Finding and denoting new lines in an Excel file

[kcoleman]

Hi all,

A team I deal with does a weekly check where they need to fine new lines in an excel sheet they get, versus the prior week's file.

Each line has a unique identifier so all I really need is to see if the identifier was in last week's file, if not then simply denote that line with a "New Line" comment or something in a column out to the right.

Any ideas? Not something I've done before and not sure where to start! 

Thank you.

[binuacs]

@kcoleman Can you provide some sample file and expected result

[atcodedog05]

Hi @kcoleman 

Here is how you can do it. In this example lets say CustomerID is the key id field

Workflow:

Hope this helps : )

[davidskaife]

Hi @kcoleman 

Does each file remain, or get overwritten with the new data?

For example if you keep the previous weeks file you can use a join tool to join the new file to the old on the unique identifier, and whatever records appear in the outer join will be the new lines which you can then flag and join back into the main workstream