combine columns but without missing values

i have a table with several columns and want to combine them for assocation rule analysis

some rows/columns have missing values

how can i combine the columns without these missing values?

Can you simply use the "Missing Values" node and choose to remove them.

 

Simon.

no, i cannot

if i choose remove the whole row is gone

i found a workaround

i used the node 'Unpivoting' to split one row in several rows, then i filtered the rows with the missing values and then i used the 'Group by' node to create a List Column with all the values for each ID

and it works :)