Hi all, I need to compare files in two different directories. Both dictories contain 350 files. I have the following requirements: * File A in directory 1 only needs to be compared with File A in directory 2 (files have only 1 tab) * Files have 1402 rows and 30 columns which need to be compared * I would like to import all files the same time. * I would like to have one export contain all rows and cells that don't match + add a column with the name of the file in which the error occured for each row. I'm new to this tool so this might be a noob question. I hope you can help me!

Compare multiple files in two directories

Hi all,

I need to compare files in two different directories. Both dictories contain 350 files. I have the following requirements:

File A in directory 1 only needs to be compared with File A in directory 2 (files have only 1 tab)
Files have 1402 rows and 30 columns which need to be compared
I would like to import all files the same time.
I would like to have one export contain all rows and cells that don't match + add a column with the name of the file in which the error occured for each row.

I'm new to this tool so this might be a noob question. I hope you can help me!

Input

Join

Accepted answers

benakesh

Hi @Mikkel94 ,

The sample wf produces this output with list of differences. Hope this helps .

compare_files.yxmd

All comments

benakesh

Hi @Mikkel94 ,

You can include a small number of sample files in dir1 and dir2 for community to develop a sample workflow .

I have added process steps .

File A in directory 1 only needs to be compared with File A in directory 2 (files have only 1 tab) : Read files in dir1 using input tool (*.*) . Read files in dir2
Files have 1402 rows and 30 columns which need to be compared : Transpose data
I would like to import all files the same time. : input tool ( *.* ) will read all files
I would like to have one export contain all rows and cells that don't match + add a column with the name of the file in which the error occured for each row. : Join data ( file name , record key , column are keys) and compare values with formula tool . Filter rows to include only difference .

Mikkel94

Hi @benakesh,

Thank you for your quick response! I think a sample workflow would help a lot.

I attached 4 files:

Directory 1: Company A and B
Directory 2: Company A and B

File A is different and file B is the same. Based on this I would like to have an export in which only shows the rows that changed and also that the changes relate to company A.

I appreciate the help!

Hi @Mikkel94 ,

The sample wf produces this output with list of differences. Hope this helps .

compare_files.yxmd

geraldo

hi,

For the sake of knowledge there is a CReW tool that compares 2 files.
The output is like the join tool there are 3 outputs. You can compare all fields or select the desired fields.
At the end of the run if there are critical errors it informs them in the log.

Have to download Alteryx Gallery install. Configure in user settings macro option

[]

LinK:

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703