i have a bunch of CSV files and an existing database schema that they are supposed to fit. is there a way to loop through the files and import them into the appropriate tables? i’ve tried a loop over the contents of the folder where they live, but attempting to write the second file throws an error that the file doesn’t match the table schema (of the first file)
i tried both the DB Writer and DB Insert nodes and get the same error (yes, having both there causes issues. that’s not the problem)
@Turret1024 you can try and use a Variable Loop end if you do not need to collect the results in KNIME (again). Also you could try and allow changing schemas at the loop end.
Then you might want to check the wiring. The DB Writer is not connected to the loop end. This might cause problems. And if both Writer and Loader are working with the same database one might be redundant.
2 Likes
one of them is totally redundant… i was just testing to see if one would work better than the other.
how do i change the schema at the loop end?
