Keep only cells with value in a table with multiple columns

Hello,

I have a table with multiple columns I’m looking for a way to create a new table with only cells that full, does anyone know how to do it ?

I doesn’t work I already tried :frowning:

Hi there.

Please, test this one.

playground.knwf (25.5 KB)

It is definitely not the most elegant solution, but it should work. At least, if my understanding of your task is correct.

It checks in the loop presence of empty values in every column and eliminate such rows. So, in the end you have only full rows of data.

UPD. The easiest solution is to use together Transponse node and Missing Value Column Filter node from Armin’s message.

BR,
Alex

Hi,

I guess you want to exclude the whole column if it contains missing values. To do that use this node:

Best,
Armin

2 Likes

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