comparing two tables

Hi @aminfazeli43,

so you want to create a measure of similarity between two workflows, correct?
In that case you can use the Extract Table Dimension – KNIME Hub node. This outputs the number of rows and columns of each table.
You then could concatenate both tables and check how the number of columns has changed and use this as a baseline for your similarity metric. The workflow could look something like this:
image
Important here is that the Concatenade node uses the option “Use intersection of columns”.

I also found a similar forum topic that might be useful for you: Count number of columns in file and compare column names

Best regards
Jörg

2 Likes