changing a value to be a combination of 2 values

Hi All,

Sorry I'm so new to Alteryx so all my questions are super basic!

Is there a way for me to apply a formula here to say if the size is big to rename the animal "big" animal

I've tried the below using an ampersand as though in excel and am getting a parse error - is it possible without appending a new column

output column: animal

if size= "big" then size & animal else animal

size	animal	name
big	dog	boris
small	cat	mark
medium	monkey	gina
small	cow	tracy
medium	cat	helga
small	monkey	benny
big	cow	tim

Help massively appreciated!

Thanks,

Help

Accepted answers

All comments

DataNath

Hey @EMPMUK - very close, you just need to amend the Syntax a little and use a + instead! If you use the following expression in a Formula tool you ought to get the expected output:

if [size]='big' then 'big '+[animal] else [animal] endif

TimN

Further example...

animals.yxmd

EMPMUK

if [size] = "big"
then
'big'+[animal]
else
[animal]

thanks so much for your quick answer - this is what I have in now but still getting parse error. Am I missing something 🤔

TimN

You need Endif at the end

EMPMUK

oooh I realise this is in an appended column, is this what I'll need to do? no way to rename in the same colunm?

TimN

IF [size] = 'big' THEN [size] + " " + [animal] ELSE [name] ENDIF

EMPMUK

Oh FGS! I'm still getting used to the change in formulae, thank you!

TimN

Just like and mark the solution if any of the replies helped.

Thanks.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703