File compare Module for Non regression testing

Hello again,

I am trying to figure out an efficient and hopefully automated way to compare two seperate files containg the same fields.

So far I have managed to make something that requires changing data in: Text to Columns; Dynamic Fields; Key; Transpose; Output

My problem is that this is very time consuming since I have about 100 different file groups to compare so I have to manually modify every single one of them.

I am also confronted with having to create a unique Key for each line that needs to be compared in every file, this Key tends to change for each file type because they contain different data. I haven't found a way around this. Maybe someone has a bright idea !

Here is what my module looks like, it is in French but I hope you get the idea:

Module alteryx.PNG

For outputs I have 4 files:

-In file 1 only

-In file 2 only

-No change

-With change

Anything would help...

Best regards,

Datasets

Custom Tools

Macros

Optimization

Data Investigation

Accepted answers

MarqueeCrew

@T-Dub,

I think that we're set on installing the macro and then calling the macro from another workflow.

Cheers,

Mark

All comments

kat

Hi @T-Dub

This might help: https://gallery.alteryx.com/#!app/CReW-Delta--Alpha-/5b41141b826fd3116445fee8

It checks whether everything is identical and spits out differences. Just note that your rows need to be in the same order on both sides.

Kind regards

Kat

T-Dub

Thank you @kat for your response and the tool !

I tried it on a pair of files and it seems to work, however I cannot seem to find a way to view the fields that contain differences, it can only view a summary of the number of differences)

I am using version 9.1 of Alteryx so I'm not very familiar with the newer functionalities of 11 (We have a shared Alteryx Server with 11 that we can occasionally)

Is there a way to view which fields and on which files there are differences?

Thanks again,

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703