Data changes Tracker
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @micky01 ,
Is this what your looking for?
Regards,
Aidan
edit -
second option for link included also.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Angelos,
Would mind sharing the workflow.
Many thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here you go @micky01
![](/skins/images/1827098B932DC033DAD60D1FA13C7E11/responsive_peak/images/icon_anonymous_message.png)