Column Combiner: Add option to skip missing cells and / or lines

Hi,

I’d like to propose adding the options to skip rows with missing values and skip cells with missing values to the Coloumn Combiner.

I.e. if you have an address split into different columns like street, street number, zip code, city, region, state etc., you can end up with an invalid value like Street 1, 13245 City, ? albeit being valid since the region / state not being required for Germany but maybe for the US.

That arbitrary example might be invalid, though. However, it should clarify out that with the current approach the data handling becomes unnecessarily complex.

Best
Mike

I agree it makes sense to be able to skip missing values, and in fact I had exactly that scenario a few weeks back.

Generally the Column Aggregator can be used instead for this scenario, of course, with the caveat that it doesn’t totally replace the Column Combiner if we want quotes to be applied to the column values prior to concatenation.

1 Like