Combining two columns to a new column

[Jay09]

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

[yalmar_m · Accepted solution]

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

[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()

[yalmar_m]

Dear @Jay09,

It depends on the date you want to maintain, If you want to keep the particular date then the formula should look like:

If isnull([particular date]) then [currrent date] else [partciular date]  endif

Otherwise it is reversed

If isnull([current date]) then [particular date] else [current date]  endif

Best,

Yalmar

[Jay09]

Hi,

what i am trying to ask was how to input the formula invoice date minus today.

Eg : 01/01/2019 - today()

[yalmar_m]

In that case I would advise you to use the datediff formula.

[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!

[LMBK]

Figured it out! one of those moments where you sit up in the middle of the night and tell yourself DUH...

set it up in the formula as an if/elseif: if 01A wasn't blank, then 01=01A, if 01B wasn't blank then 01=01B, etc.