Hello together, I am currently trying to create the following in KNIME. We have a CSV file that is read in with the CSV reader. First we check if it is only a string, because we want to analyze only the strings. Now we want to check if one of the columns contains a currency or not. We therefore check all columns to see if they contain three capital letters. This is the first indication that it could be a currency. We have created another table that contains all possible currency codes. The table should now be compared with the currency table and only be used if it really contains a currency. My question now is. How can I set up this comparison? I don’t know how to compare a table with a second one “only” without putting them together via a join. Does anyone here have an idea? Thanks a lot Julia Gawin

Internal comparison of two CSV tables

mlauber71 May 15, 2023, 8:56am 3

@jgawin maybe you could use a RgeEx extraction to get all the three capital letters and then filter by the matching rows:

4 Likes