I'm preparing a reconciliation report, checking if all three files (A, B, C) have same data for each RootID.
I want to check for all rootIDs, taking the first rootID i.e. first row from each file and transposed a preforming operations and outputting a template sheet for that ID, and then next it should read second rooID (second row) from each file and do the same.
Formula --
IF ([FileA_Value]==[FileB_Value] AND
[FileB_Value]==[FileC_Value]) THEN "PASS"
elseif ([FileB_Value]=[FileC_Value]) then "PASS"
ELSE "FAIL" ENDIF
I have created a workflow having a container for each rootID (I have created two containers like the below attached). I know this is not a good solution and fail if I have hundreds of rootIDs.
Can this be turned into a macro? I don't know how to implement a macro for this.
I have attached all three files and my final output, cannot attach the workflow because of company restrictions.
Hi @hf14 ,
without your workflow we can't do anything but advise.
You can create a batch macro and run the workflow for each root ID. This would be your control parameter value, and so you would not need to create hardcoded containers for each RootID.
You can find out more about batch macros at the links below.
I hope this helps,
M
https://help.alteryx.com/20221/designer/batch-macro
Hi @mceleavey
I have created a batch macro, it is perfectly outputting different sheets for each rootId but the data in there is coming weird. Why is one-to-many mapping happening there? Can anyone please solve this. Attached my current output and my desired output as well.
@jdunkerley79 @mceleavey
can anyone help?
Hi @mceleavey
I have created a batch macro, it is perfectly outputting different sheets for each rootId but the data in there is coming weird. Why is one-to-many mapping happening there? Can you please solve this. Attached my current output and my desired output as well.