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
Hi Qiu
That is just 3 blank extra columns after each set of mapping because post this mapping step I will apply formulas and match the File A, File B, File C values to get either 'TRUE' or 'FALSE' results.
Those green columns can remain blank I will apply formula step later.
Hi All, Any help or suggestion which can achieve the above results in alteryx is welcome. Plz assist.
@Qiu - Did you have any luck or any suggestions which will help me reach my expected result.
@skotian1289
Sorry so far not getting anything worthful.
But will keep trying, and kinda busy with work recently.