Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

How I can change the field value based on the second field

Highlighted
Atom

Hi!

 

I have the problem the change the field value based on the second field. Could anybody help me?

I tried next formula, but I get the Title field to 0

 

IF [Name] = "Norman" THEN [Title] = "Nurse"
ELSEIF [Name] = "Damien" THEN [Title] = "Doctor"
ELSEIF [Name] = "Kaarin" THEN [Title] = "Assistent"

ELSE [Nimike]
ENDIF

Highlighted
Atom

There were mistake, but it's not reason. IT was only translation error.

 

IF [Name] = "Norman" THEN [Title] = "Nurse"
ELSEIF [Name] = "Damien" THEN [Title] = "Doctor"
ELSEIF [Name] = "Kaarin" THEN [Title] = "Assistent"

ELSE [Title]
ENDIF

Highlighted
Alteryx Certified Partner

Hi @Ninjago,

 

Select the field you want to update or create one then writes as follows:

 

IF [Name] = "Norman" THEN "Nurse"
ELSEIF [Name] = "Damien" THEN "Doctor"
ELSEIF [Name] = "Kaarin" THEN "Assistent"

ELSE "[Title]"   // or whatever vale you want to pass.
ENDIF

 

Thanks,

Vishwa

 

 

 

 

Atom

Thanks this works:

IF [Name] = "Norman" THEN "Nurse"
ELSEIF [Name] = "Damien" THEN "Doctor"
ELSEIF [Name] = "Kaarin" THEN "Assistent"

ELSE [Title]
ENDIF

Labels