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)
@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.
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?
You would just use the Variable Loop End – KNIME Community Hub node
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
