Hi, I’m trying to use Knime to compare two tables in different databases, cell by cell and also column names. I’ve connected to both DBs (one Snowflake, the other postgres) and can query the two tables. However Snowflake returns column names as uppercase, postgres returns lowercase. I’m sending both returned datasets into a Table Difference Finder Node. It highlights everything as different due to the case of the column names. Is there a way to get Table Difference Finder to ignore the case of the column names while still executing the comparison? Thanks! Tony

Compare DB Tables including column names but ignoring case

rfeigel May 9, 2024, 1:46pm 2

This should help.