Hi,
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
z
a x y
…
I want to extract the letters of all columns that no letter is missing
f.e.
Col1
a
x
y
z
I would appriciate your help 
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?
Br,
Ivan
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.
Thank you very much that helped a lot.
Sorry for the “easy” question
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
