Stacking Columns

I ma new to knime and i have a question regarding tacking 2 columns to one.
My dataset looks like this.
Col1 Col2 Col3 Col4…
x y z a
z a
a x y

I want to extract the letters of all columns that no letter is missing
I would appriciate your help :slight_smile:

Best Regards

Hello @Jace746,

and welcome to KNIME Community!

Not sure I understood it properly but maybe you are looking for Unpivoting node to bring multiple column values into one column? Then if you would like to keep only unique vales you can use Duplicate Row Filter node. Or do you need something else?


1 Like

Hi @Jace746 , and welcome to the Knime Community.

I’m not sure I understand either. It’s not clearly explain what is it that you want.

Do you mean to get a list of all possible letters that are in the table? So looking into all cells (all rows and all columns), and then return all these letters as a unique list in 1 column?

If that’s the case, then I would with what @ipazin has suggested.

I can’t think of what else do you mean from what you said and from the sample result you generated.

1 Like

Thank you very much that helped a lot.
Sorry for the “easy” question

1 Like

Glad it elped @Jace746 and no need to apologize. This is not that obvious :wink:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.