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
