I have built dataflows from customer input data in the Asure data factory. We designed the Workflows which are built on Alteryx(another Etl tool) in Azure data factory.
Now testing the sample data is ok on both sides.
But how to validate the entire output of Alteryx and Azure be matched/Validated? Is there any tool?
My output file format is CSV.
Is there any automation process to validate all the rows of Alteryx output and Azure Output so that I can be sure that I have built the right Dataflow logic?