Data Validation

[AKHAN]

Hello, need help in sample workflow for data validation.  There are two table in excel Dataset-1 & Dataset-2, need to compare both or validate and produce new output by differences either color code or incorrect values. Attached here is the two data sets. 

[mceleavey · Accepted solution]

Hi @AKHAN ,

I used the method of transposing the data on each dataset, then joining together on the key fields and the column names.

Then I simply created an if statement to compare the two sets for differences.

Workflow attached.

I hope this helps.

M.

[AKHAN]

In my earlier workflow I did not use Transpose which increase my workflow. Thanks a lot for suggesting simplifying workflow. Appreciated it. 

[mceleavey]