Combining two columns to a new column

Hi,

I have few data (Eg. names) in Col A and few in Col B and few line items both in Col A and Col B. Can anyone please help me how to get the whole data in new col ( may be in Col C) in alteryx . below is the example how the data is look like.

Col A Col B Col C

(expected output)

John John

Mike Mike Mike

Paul Paul

Dave Dave Dave

Rojer Rojer

Connectors

Accepted answers

yalmar_m

Dear @Jay09,

I think this solution is suitable for you.

It uses Col A if it is not null else it will use Col B.

Best,

Yalmar

Col C_YM.yxmd

All comments

yalmar_m

Dear @Jay09,

I think this solution is suitable for you.

It uses Col A if it is not null else it will use Col B.

Best,

Yalmar

Col C_YM.yxmd

Jay09

Dear Yalmar,

Thanks a lot for your valuable response.

Can you also please tell me how to use date formula for the below scenario.

Particular date - current date.

Eg: 01/01/2019 - today()

LMBK

this is awesome! Now how do you do it with 3 columns (e.g., 01A, 01B, 01C ==> 01). I tried extending the isnull logic and then tried to go backwards with isinteger and both times wound up with only 01A moving into 01. Thank you in advance!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335