Compare two excel/csv files unit test style

[loneranger]

Hi

I have a several pairs of excel files which I need to compare. Is there a way in Knime to do this in unit test style and give me a report of which file pairs differ and if so how (e.g. columns do not match, rows do not match, which rows are not common etc?)

Thanks

[oole]

Hi @loneranger,

I did a quick search on the KNIME Hub and found this workflow by @ipazin.

Here’s the post from which the workflow originated:

data set comparison

Hi there, In Column Expressions node you can also specify column by its index. So column(0) is addressing first column in your table. If you have a fix number of columns you can use that trick. To use Column Comparator in a loop you can try something like this: [TableComparison] And here is workflow on KNIME Hub. It works if tables have same structures. Take a look and if any questions feel free to ask. Br, Ivan

I think this might go in the right direction.