QUESTION --> IF c THEN t ELSE f ENDIF

Hi There,

good morning,

I am stuck trying to get a Workflow done, this is my issue: in a table I have different customers under [consignee names] but each customer goes to a different terminal (new column that i would like to create with that terminal, so I did a formula using IF for the first customer, but I don't know how to create it for the next customers.

Ex (everything ok through here).

IF [Consignee Name]="Customer1" THEN "Column AA" ELSE "" ENDIF

So I need to continue the formula adding

Customer 2 to Column AB

Customer 3 to Column CD

etc etc.

Any help I will appreciate it.

Thanks in advance,

Tips and Tricks

Accepted answers

SamDesk

Hello @PedroPerdomo

Apologies I forgot to add in the final ELSE statement into the IF statement. It always requires an ELSE statement for any other values that are passed through the formula and if they're not important then I would usually just set them to NULL.

Amended Formula:

IF [Consignee Name] = "Customer1" THEN "Column AA" 
ELSEIF [Consignee Name] = "Customer2" THEN "Column AB" 
ELSEIF [Consignee Name] = "Customer3" THEN "Column CD" 
ELSE Null()
ENDIF

Sam

ChrisTX

@SahadhKuruniyan can you post your workflow?

Is your field name spelled correctly?

"Differeces" versus "Differences"

Chris

All comments

SamDesk

Hello @PedroPerdomo,

You can do this using the ELSEIF functionality in the Formula tool:

IF [Consignee Name] = "Customer1" THEN "Column AA" 
ELSEIF [Consignee Name] = "Customer2" THEN "Column AB" 
ELSEIF [Consignee Name] = "Customer3" THEN "Column CD" 
ENDIF

Hope that helps!

Sam

PedroPerdomo

Hi Sam,

thank you,

but i am still getting Malformed if Statement and ENDIF (shows with a red underline).

you know why?

PedroPerdomo

2018-11-14 12_19_59-Window.jpg

Barclaysusercds

I want to use the IF formula but it does not like my less than <. What is wrong with the below?

Thanks

IF [RACE_ACCT]<20000000 THEN "Long" ELSE "Short" ENDIF

ChrisTX

@Barclaysusercds the formula looks OK, depending on data types.

What is the data type for the field [RACE_ACCT]? It should be numeric, since your formula uses a numeric value.

And what is the data type of the field you are writing to in the Formula tool? If you're updating an existing field, is it a String data type? If you're creating a new field, did you set the Formula tool to create a String data type?

Chris

Barclaysusercds

Ah ok [RACE ACCT] was VWString, I changed it to Double and it worked. Thank you.

APGUIMARAES

I am having the same issue, but no idea how to solve it.

Captura de tela 2024-10-18 141335.png

ChrisTX

@APGUIMARAES an IF function must have an ELSE clause. What do you want the value to be if the first two IF clauses are not true?

You can use "Null()" without the quotation marks in the ELSE clause.

Chris

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703