Hi
I have two columns
DATA 1 | DATA 2 | Expected Output | |
1 | LION | CAT | LION/CAT |
2 | CAT | CAT | |
3 | CAT | CAT | |
4 | LION | LION | |
5 | LION | LION | |
6 | |||
7 | |||
8 | |||
9 | LION | LION |
Since row no: 6,7,8 are nulls in both the columns it should also fill with "CAT" in expected output
Solved! Go to Solution.
is there any other way so we can minimize the usage of tools
record id not and row numbers are not required
Hi @BRRLL99
Without recordID tool, I cannot join back with the original dataset.
We need a unique column, hence needed record ID tool for sure.