join columns into one

[cmunoq]

Hello everyone, I need help, I have several columns and I need to join them into one, example

Column 1 Column 2 Column 3
122345 23456 34567
1234 3456 9876

i need this:

Column 1
122345
1234
23456
3456
34567
9876

I am learning to use the tool and cannot do this, thanks

[HansS]

Hi @cmunoq

I created this workflow all_columns_to_one.knwf (21.6 KB) it uses a Column List Loop to process every column one by one . To have them into one column a the end, all columns are renamed to a single name. And in case of missing values (?) they are filtered. Hope this helps.

gr Hans

[morpheus]

Hi @cmunoq,
you can use the unpivot node. After unpivoting you get 2 Columns. One column contains the column headers of the previous table and the other column the corresponding values. The only thing what you additional need is at least one unique identifier for your table rows in your source table e.g. ROWID.

BR
Hermann

[ipazin]

Hi there,

for that order you can also try Transpose, then Create Collection Column followed by Ungroup

Br,
Ivan