Dynamic column usage

Hello all,

I have a question, I should replace values in column1 by values in column2 if they are NULL.
But I should do it dynamically, becaese if values in column3 are NULL then they should be replaced by values from column4…column5 by column6 and so on.
For example:


at the end should be:

Please help.

Best,
Ram

Hi @IMR2KA,

A possible solution is to transpose your table and then use the -Missing Value- node with “Next Value*” option as follows:

Hope it helps.

Best
Ael

5 Likes