Compare DB Tables including column names but ignoring case

KNIME Analytics Platform
1

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

2

This should help.

3

Thanks @rfeigel - I can’t find the Insert Column Header node though. Is it called something else these days?

4

https://www.google.com/url?sa=t&source=web&rct=j&opi=89978449&url=https://forum.knime.com/t/insert-column-header/73251&ved=2ahUKEwiX-cLX6ICGAxV6kYkEHe_uA2oQFnoECBcQAQ&usg=AOvVaw1kiQUKMbyjCRM8sED4MYg3

5

Hi @tonyb, using the mechanism as described by @rfeigel, for convenience, I have a component which you can feed in both tables and it renames the top table’s columns to those of the lower table.

1 Like
6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.