Hello All,
I am trying to reconcile attributes from 3 different files together but I want to give user the option to select which attributes to reconcile with each other based on a mapping file.
I have Joined the 3 file values together based on Unique IDs Unique Reference and Reference ID and got them together. In my next step I want the User Mapping to kick in arrange the fields accordingly so they can reconciled . The User can change Attributes but I want tool to adjust accordingly . Not sure if it is achievable, hence m looking for some expert assistance.
I have attached the 3 sample inputs plus a Sample Mapping file and the current tool output - expected output (In one excel but in separate sheets), if that helps to understand what I am trying to achieve. Any help is appreciated as I am stuck.
Regards