topic IF Statement in Alteryx Designer Desktop Discussions

IF Statement

RedaS — Tue, 29 Oct 2024 17:25:06 GMT

Hello:

I cannot get this IF statement to work. I believe it has to do with the data type for the Geo Code data. Any suggestions?

Re: IF Statement

Hub119 — Tue, 29 Oct 2024 18:20:39 GMT

@RedaS I'm guessing the first record in your dataset does not have "CT" in the State Code field. That is why the Geocode field appears to be staying the same as what you have already established in the above formula. Try running your workflow and check to see if the records associated with a "CT" State Code have actually been updated, as the formula as written should work.

Re: IF Statement

RedaS — Tue, 29 Oct 2024 20:24:38 GMT

@Hub119 I double check and the State Code contains "CT".

When I run the workflow, it returns warnings Invalid type in operator ==.

Re: IF Statement

atcodedog05 — Tue, 29 Oct 2024 20:35:07 GMT

Hi @RedaS

Your formula should be something like this

IF [State Code]="CT"
THEN "07000000"
ELSE [GeoCode]
ENDIF

Hope this helps : )

Re: IF Statement

Hub119 — Tue, 29 Oct 2024 20:50:32 GMT

Misread that... @atcodedog05 is correct, you need to remove the "[Geocode]=" part of your formula as that is already being referenced.

Re: IF Statement

RedaS — Tue, 29 Oct 2024 21:18:37 GMT

Thank you, it worked!

Re: IF Statement

atcodedog05 — Tue, 29 Oct 2024 21:23:22 GMT

@RedaS Happy to hear that :)

Can you mark response as solution. So that this post gets marked as solved.

Happy to help : )

Cheers and have a nice day!