Hi there, I'm just beginning with Knime to do some CSV extraction, mysql joining etc. but there is some things I don't conceptually know how to do.
- I have a CSV file with a column "USERS", containing 3 rows: UserA, UserrB, UserC
- I have an SQL database containing a table USERS with all users name.
Basically, I want to check if my 3 users described in the CSV are existing in the DB (in this exemple it won't be the case because of a mistyped 'UserrB')
I started like this :
1) CSV Reader + Column Filter (to keep only the USER column) + GroupBY (to keep single values)
2) Database Reader (which select all the users from the USER table)
then, I whish a way to "compare" or maybe "check" if the results of 1 are also in the results 2. However the method, a simple "red sign" of the node will be OK for that since the project should check the structure and the content of a CSV file.
I hope to be clear enough !