Else IF then Malformed Statement

Hi Community,

Need some help please

I have a column I need to pull the 3rd digit from Examples (11102,11202, 13401, 14104, 12701, 11209)

So I want to say if the 3rd digit is a 1 code it as complete, else if the 3rd digit is a 2 code it as a part, everything else code as an other.

I split the column using Substring([siopseg3],2,1) I think this will bring back digit 3, then I want to create IF / Then / Else Logic

Can someone please advise what I'm doing wrong please.

TIA,

Karl.

Workflow

Accepted answers

atcodedog05

Hi @Karl_Spratt

[part /completes] is a string column hence use condition like

[part /completes]="1"

With quotes

Hope this helps : )

All comments

Thableaus

Hi @Karl_Spratt

You're mixing data types. Try to add double quotes to the numbers = "1", = "2", cause your field is a String.

Cheers,

atcodedog05

Hi @Karl_Spratt

[part /completes] is a string column hence use condition like

[part /completes]="1"

With quotes

Hope this helps : )

Zas3nfkb

Can you try putting quotes around your numbers? You are defining them as strings in the above function. Otherwise, change the first formula to output number.

Karl_Spratt

Thableaus and atcodedog05

That worked guys, really appreciate your help here.. was looking at it and couldn't work out the problem. Duh!!!

Cheers,

Karl.

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335