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.
Column A Column B New Column
XYZ RAM RAM
DTC TXT TXT
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:
Thanks a lot. It working…
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.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.