many to one filter for missing values

Hi all

I have a data set with two columns with a start date. If the date is in column a, the value in column b is missing ("?"). I am trying to combine this into one column with the start date.

I used a many to one node, bu I can seem to find the correct regexp. Maybe I should use a dfferent node?

Any ideas?
kind regards
Bas

Hi @Bas1111

Try the Column Aggregator node.

gr, Hans

2 Likes

Hi Hans

This works. I have to remove the “?” that is copied, so there might be a cleaner solution. But for now this does the job.

Bas

1 Like

Hi there @Bas1111,

Column Merger node should do the trick :wink:

Br,
Ivan

1 Like

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