Combine two columns and blanks with specific text

[BRRLL99]

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

[ShankerV]

Hi @BRRLL99 

Please find the expected output.

Many thanks

Shanker V

[BRRLL99]

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

record id not and row numbers are not required

[ShankerV · Accepted solution]

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.

[ShankerV]

Hi @BRRLL99 

Please find by less tools.