How can I specify the names of columns output by Cell Splitter and Column Splitter and anything else..

KNIME Analytics Platform
1

Hello
I’m new (!) and building my first project… I am reading a text file and want to spilt it into columns. I’m using things like the delimiter string etc to do this I have about 6 or 7 column and cell splitters strung together that gradually split the text into fields… This all works fine…

A couple of questions.

  1. Is there some other way / node I should be using to do this?
  2. Assuming not, is there a way to name the columns as they are split out? Names like ‘Artist’ or ‘Number of’ would be easier to use in the next node. The start of my flow is a file reader and I did manage to set the name of its single column by double clicking on it, but this doesnt work downstream… How can I change the names?

Thanks
dpr

2

Hi @dpr -

As far as string splitting goes, you are probably on the right track. If you want to rename your variables, you can use the Column Rename node.

Feel free to post an example workflow if you have more questions!

3

Thanks. Column Rename was what I needed. A bit surprised it has to be a seperate node as the number of nodes gets large quickly!