Data changes Tracker

[micky01]

I have two files

- Before Data changes
- After Data Changes

On the Before Data changes file i have list of below columns
PRODUCT PARENT ID
PRODUCT SUB CODE
CATEGORY

On the After Data changes file i have list of below columns
PRODUCT PARENT ID
PRODUCT SUB CODE
CATEGORY

On the After changes file all the Category values have been renamed to new names.

I want two out put files

first output will contain is for each Distinct PRODUCT PARENT ID what the Old Values and New Values for CATEGORY field

in the second Output file By each PRODUCT SUB CODE what the Old Values and New Values for CATEGORY field.

Attached the workflow any thoughts on how to start with would be much appreciated

[Aidan_K · Accepted solution]

Hi @micky01 ,

Is this what your looking for?

Regards,

Aidan

edit - 

second option for link included also.

[AngelosPachis]

Hi @micky01 ,

You have to use a summarize tool to get the different values for each Product Parent ID and Product Subcode between the old and new value.

Then once you have that, it's just a matter of bringing back your old and new values together with a join and union to compare the old/new values.

Hope that helps,

Angelos

[Aidan_K]

Apologies, my suggested solution doesn't take into consideration any items that are unique to the 2nd table... e.g. parent "P4"

The correct solution is from @AngelosPachis 

[micky01]

Hello AidanKing,

Thank you for your quick solution and  it works.

Would you mind help me to alter the output to bring the below columns.

PRODUCT PARENT ID

PRODUCT SUB CODE

OLD_CATEGORY

NEW_CATEGORY

Thanks

[Aidan_K]

Hi @micky01 ,

You can add / remove (or reorder if necessary) any columns if you select any of the Join tools and then select the checkbox beside each column.

Note - Please refer to the point on the "P4" parent items (under separate comment) to be sure your happy with the outputs. 

Regards,
Aidan

[micky01]

Hello Angelos,

Thank you so much for your solution 

 Would you mind help me to alter  and bring one output file  to bring the below columns.

PRODUCT PARENT ID

PRODUCT SUB CODE

OLD_CATEGORY

NEW_CATEGORY

Many thanks

[AngelosPachis]

Hi @micky01 ,

You can use a Join tool to bring that information of Product Sub Code from either your old or new dataset by joining on the field Product Parent ID.

Does that work for you?

[micky01]

Hello Angelos,

Would mind sharing the workflow.

Many thanks

[AngelosPachis · Accepted solution]

Here you go @micky01