Hi I have two columns DATA 1DATA 2Expected Output1LIONCATLION/CAT2 CATCAT3 CATCAT4LION LION5LION LION6 7 8 9LION LION Since row no: 6,7,8 are nulls in both the columns it should also fill with "CAT" in expected output

Combine two columns and blanks with specific text

I have two columns

Since row no: 6,7,8 are nulls in both the columns it should also fill with "CAT" in expected output

Without recordID tool, I cannot join back with the original dataset.

We need a unique column, hence needed record ID tool for sure.

Please find the expected output.

Many thanks

Shanker V

is there any other way so we can minimize the usage of tools

record id not and row numbers are not required

Without recordID tool, I cannot join back with the original dataset.

We need a unique column, hence needed record ID tool for sure.

Hi @BRRLL99

Please find by less tools.