I have a table that repeats column pattern DATE / STRING / AMOUNT
This is a result of creating a collection column and after some nodes, append some collection lines. (see table1)
When I,ve made a Split collection Column, the result was a huge table that repeats de columns (see table2)
DATE / STRING / AMOUNT / DATE / STRING AMOUNT / DATE / STRING / AMOUNT
I am trying to find a way to make a loop or other way to create a collection column for each 3 columns.
Then I will Transpose this new collection table and then split the collection, in order to create a table that contain the data only in 3 columns
May you help me?
Here is my suggestion:
collection.knwf (57.7 KB)
Feel free to ask your questions after checking the workflow and let me know if it’s what you were looking for.
Armin, thank you very much for your help. I am a begginer user of knime.
Is it possible to get the outpu table in just one collumn?
What I am trying to get is just one collumn for the field data, one for string and one for the amount
The result should be a tabel with 3 collumns and 1,065 rows, considering the null data.
If I’m getting you right, this should be what you want:
collection.knwf (112.2 KB)
The dataset you have provided has 11 rows and 216 columns so we have 2376 cells. By dividing it to 3 we have 792 which is the number of rows including missing values. By excluding missing rows we have 127 rows.
I’m here to answer any further questions.
Perfect!!! Thank you very much!!
You are so kind!