I am doing a text analysis of learning outcomes. My file consists of a single column of text with a Header SLE.
After loading the EXCEL file, I want to use KNIME’s Row IDs to name my documents.
If I want to name the documents in my workflow, I see that I have three options: (1) choose the strings in a column, (2) use the RowID, or (3) use an empty string.
When I choose Row ID, I find that the names of my documents are not the to-be-expected “Row1”, “Row2”, etc.
Here is a screen capture of the preview field of my Excel Reader configuration window:
Hi @rdarrenstanley,
maybe the reason is that in your loaded excel file the records are sorted by rowindex (numeric!) and not by rowid. In the document viewer the records are sorted by ‘Document Title’ (alphanumeric!).
So i guess if you scroll down you would see also find Row2 and Row3 at the place a sorted list string would have it.
For e.g. Row2 at least after Row199 (if this document exists).
I agree with @morpheus’s answer (thanks!!) – it’s a sorting problem due to how the data type can handle sorting (string data type vs. numeric data type sorting).
It is perhaps more likely that I am simply confused because I am new to KNIME. Still, in the third image, under SLE Documents, the names of the docs are all “Row1”, “Row2”, “Row3”, etc. But under Document Title, in the fourth image, the names are different. Should they not be the same? This appears more like a KNIME issue than an EXCEL issue…or maybe it is a ME issue!
Thank you for your response, Robert. Although I read about the different forums and their purpose, I was not clear where I should post things like this. So next time I shall go to the KNIME Analytics Platform category for queries like this.
