Compare 1 file against 15

[ag72]

Hello, 

I have 15 files, data from the each file needs to be compared against the remaning 14 one by one - so what's the best way to do it using macro or autoamted process?

file names are like 1, 2, 3,4 ,5 each representting data from one day. 

Thanks

[binuacs]

@ag72 you can use batch macro to compare these files

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309