How do I build new data from csv and excel files?

hi Gurus,
I have two different format data file: csv, excel, I plan to build new data using part of every file.
How do I build new dataset in Knime.
Thanks.

Hi there!

Reading each of above files into KNIME (using File Reader and/or Excel Reader node) will create two data sets in KNIME. Then depending what you need to do you can use Joiner node to join data sets, Concatenate node to add rows, Column Appender to add columns… Before that you will maybe need to do some string manipulations, rename columns, filter rows or columns…

This is a good example to learn ETLs in KNIME:

https://nodepit.com/workflow/public-server.knime.com%3A80%2F_Example_Workflows_from_Installation%2FBasic%20Examples%2FData%20Blending

Good luck,
Ivan

2 Likes

Hi Ivan, Thanks!

1 Like