Find changes in database extracts

ulrich_schumann

We have an application with a database behind (some thousand records). Each month we receive an extract of the latest data from the database. I would like to see which entries in the database have been updated this month. I would like to count any change to any column as just one change per ID. Optional: If possible I would also like to know with fields have been updated (no details needed, just name the fields with an update).

I have included an example of the data with results I like to see.

Any ideas how to solve this with Alteryx?

Count Changes.xlsx

Common Use Cases

Accepted answers

This is the sort of thing I meant. You may need to use Record ID tool if you care ordering the data in some other way.

Cheers,

Iain

Count Changes.yxmd

All comments

Hi,

I think that sorting the data by ID and Reporting month and then using a Multi-Row Formula should be able to get the results you are looking for.

Cheers,

Iain

This is the sort of thing I meant. You may need to use Record ID tool if you care ordering the data in some other way.

Cheers,

Iain

Count Changes.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703