First and last value of each row

Hi,
I have a table with some Missing Values. For each row I need to extract the leftmost value (First_value) and the rightmost value (Last_value) which is not missing (see attached image).
What is the best and quickest (the data set is large) way to do that?
Many thanks in advance!

You can do this with the Column Aggregator with the Option First and Last.

3 Likes

A Column Aggregator node. Use a wildcard pattern with ‘*’ as the pattern to include all columns, and then the options tab you can choose ‘First’ and ‘Last’. Keep the checkbox in the ‘Missing’ column unchecked.

Steve

3 Likes

That´s exactly what I was looking for - thank you so much guys!

1 Like

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