With KNIME howto create an SQLite inmemory database

[siebrasse]

Hi all,

I’m an absolute beginner with KNIME.

I do have a bung of csv file that I want to analyse with KNIME. My idea is to read all the csv files into an SQLite database and than have KNIME analyze it.

So far I have found the SQLite Node. But now how to create a inmemory database.

All help is good, but please explain it to as much detail as you can.

Thanks

[ActionAndi]

Hi,
welcome to the KNIME forum.
Have you checked the settings of the node? There’s an in-memory option already pre-selected

[rfeigel]

Just curious. Why do you want to create a SQLite database? Why not just analyze the data directly from the csv files?

[siebrasse]

Thank you. I found that indeed there is no reason to first have it in a SQL db before analyzing.

[siebrasse]

Thank you, yes I found that option but than I had no idea how to proceed from there. In the mean time I think analyzing the data straight form the csv is the way to go.