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.
