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