how to replace a blank cell from another column

[dimple5abi]

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

[qqilihq]

Hi Dimple,

this can easily be done with a Rule Engine node:

Rule Engine — NodePit

Here’s the rules:

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

Find the example workflow on my NodePit Space:

Replace_a_Blank_Cell_From_Another_Column_15332 [Workflow] — NodePit

– Philipp

[dimple5abi]

Thanks a lot. It working…

[dimple5abi]

Hi Sir,

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

[qqilihq]

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.