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

[micky01]

Thank you so Much Angelos Much appreciated.