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
Solved! Go to 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
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()
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
Hi,
what i am trying to ask was how to input the formula invoice date minus today.
Eg : 01/01/2019 - today()
In that case I would advise you to use the datediff formula.
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!
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.