Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Simple if else formula failing. / Formula (64) String variable switched type Record #4

Hamder83
11 - Bolide

HI 

I have two values I wanna pass through this formula:
1.: [SubCarrierNameUB] = 'GLS Austria Parcel'
2.: ParcelNumberPurchase

Both fields are text.


Hamder83_0-1644826988745.png
Hamder83_1-1644827004070.png
Then I generate a new field in a forumla:
IntegrationParcelNumber which is text too.

And I do this formula:

if


[SubCarrierNameUB] = 'InPost Parcel'
THEN
[ParcelNumberPurchase]


ELSEIF
[SubCarrierNameUB] = 'Bring Denmark Parcel'

and left([ParcelNumberPurchase], 2) != '00'
THEN
"00"+[ParcelNumberPurchase]


ELSEIF
[SubCarrierNameUB] = 'Bring Denmark Parcel'

and left([ParcelNumberPurchase], 2) = '00'
THEN
[ParcelNumberPurchase]

 

 

ELSEIF
[SubCarrierNameUB] = 'Postnord Norway Parcel'
AND
StartsWith([ParcelNumberPurchase], "707")
THEN
[ParcelNumberPurchase]

ELSEIF
[SubCarrierNameUB] = 'GLS Germany Parcel'
AND
StartsWith([ReceiversReference], "00157") or
StartsWith([ReceiversReference], "00257") or
StartsWith([ReceiversReference], "00557") or
StartsWith([ReceiversReference], "00657") or
StartsWith([ReceiversReference], "00957")
THEN
[ReceiversReference]


ELSEIF

[SubCarrierNameUB] = 'GLS Germany Parcel'
AND
StartsWith([SendersReference], "00157") or
StartsWith([SendersReference], "00257") or
StartsWith([SendersReference], "00557") or
StartsWith([SendersReference], "00657") or
StartsWith([SendersReference], "00957")
THEN
[SendersReference]


ELSEIF
[SubCarrierNameUB] = 'GLS France Parcel'
AND
StartsWith([OrderNumberCustomer], "00157") or
StartsWith([OrderNumberCustomer], "00257") or
StartsWith([OrderNumberCustomer], "00557") or
StartsWith([OrderNumberCustomer], "00657") or
StartsWith([OrderNumberCustomer], "00957")
THEN
[OrderNumberCustomer]

ELSEIF
[SubCarrierNameUB] = 'GLS Ireland Parcel'
AND
StartsWith([ReferenceCustomer], "00157") or
StartsWith([ReferenceCustomer], "00257") or
StartsWith([ReferenceCustomer], "00557") or
StartsWith([ReferenceCustomer], "00657") or
StartsWith([ReferenceCustomer], "00957")
THEN
[ReferenceCustomer]

 

 

 

ELSEIF
[SubCarrierNameUB] = 'GLS Germany Parcel'
and
Length([ParcelNumberPurchase]) = 12
THEN
Left([ParcelNumberPurchase], 11)

 

ELSEIF
[SubCarrierNameUB] = 'DHL Netherlands Parcel'
THEN
"00"+[ParcelNumberPurchase]

 

 

ELSEIF

[SubCarrierNameUB] = 'GLS Belgium Parcel'
AND
StartsWith([SendersReference], "00157") or
StartsWith([SendersReference], "00257") or
StartsWith([SendersReference], "00557") or
StartsWith([SendersReference], "00657") or
StartsWith([SendersReference], "00957")
THEN
[SendersReference]

ELSE
[ParcelNumberPurchase]

ENDIF

 

 

Since the subcarrier is not in this list, I expected it to just fill ParcelNumberPurchase into my new IntegrationParcelNumber?
But it comes out empty:

Hamder83_2-1644827192912.pngHamder83_3-1644827205329.png

 

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @Hamder83 

 

Can you share your formula tool config?

Labels
Top Solution Authors