how to replace a blank cell from another column

Hi,

I have value in Column A and value in Column B. There are some columns are missing in Column B. I want to create a new column, where it will pick value from Column B and wherever a value is missing, it will pick value from Column A.

Desired output
Column A Column B New Column
ABC ABC
XYZ RAM RAM
DTC TXT TXT
RAM RAM

Please help
Regards,
Dimple

Hi Dimple,

this can easily be done with a Rule Engine node:

Here’s the rules:

MISSING $columnB$ => $columnA$
TRUE => $columnB$

Find the example workflow on my NodePit Space:

– Philipp

4 Likes

Thanks a lot. It working…

1 Like

Hi Sir,

Can you please help me with IF ELSE condition in rule engine. I am unable to apply it…

The Rule Engine applies the given rules sequentially. This way it should be easily possible to map if-else conditions.

PS: Please do not cross-post and repeat your questions over the forum (I’ve just noticed that). It just causes a mess and unnecessarily wastes peoples’ time. Thank you.

2 Likes

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