My dataset (large multiple text files) after CSV Reader step looks like that:
I am trying to add a column (2 actually) to the above set.
The column name and value are highlighted above so 1st column needs to be called FundID with value which is currently blacked out and 2nd column is FileFormat with corresponding value.
How to go about it , please? Potentially setting variable for each element?
Seems like ‘constant column value’ works just fine for the above.
However as I have a multiple file , I suppose , i would need to add constant column value node to each text file before combining them all - can someone confirm, please?
That seems like a lot of nodes if I have 20 text files.
In case of multiple files, adding two columns for each file and concatenating would be easier, especially if each file will have different values inside the two columns. If the values are always constant, you can also concatenate and then create the two columns.
HI @lelloba , thanks for this but I dont think ‘column expression’ exist anymore as a node - there is no clear information what it has been replaced with.
I tried the following solution but it takes an enormous amount of time to convert the data (not surprising as my data has over 2 million rows):
My heart missed a beat when you said “I dont think ‘column expression’ exist anymore as a node”. I use it extensively and cannot live without it Column Expressions – KNIME Hub
Select just the column you need to transpose, otherwise it will take too much time!
However, was my solution working for you? Why do you need to transpose the dataset?
Column moving/copying node is not working (either with copy nor with move) - please see below:
Moreover, it unexpectedly shuts down my KNIME which suggest some deeper issue.
All of my values in first row are string so that should not be an issue.
2
Can you please elaborate on 1st solution - selecting row5 and transpose - not sure how to select row5 and also transpose does not give me any intuitive option I can select: