Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Malformed IF statement with concatenant

keithlawrence
6 - Meteoroid

Hi,

 

I'm pretty brand new to Alteryx (2 days) so I'm going to ask a simple question. As a business, we're moving the script from QlikView to Alteryx so it's like trying to learn a new language and I'm failing :(

 

Why is this formula giving me a Malformed IF statement:

 

If IsNull([PO Line Catalogue ID])

THEN

Null()

ELSE

[PO Line Catalogue ID] + " - " +

Uppercase([PO Line Description]) + " - " +

[PO Line Unit Price - Original] + " - " +

[PO Line UOM] + " - " +

[PO Line eClass Code]

 

I'm sure it's easy but I can't figure out what's wrong

12 REPLIES 12
vishwa_0308
11 - Bolide

You need to change your numeric fields to string type. use toString() and then it will get passed.

keithlawrence
6 - Meteoroid

That's removed the Malformed IF but not I've got Type Mismatch in operator

keithlawrence
6 - Meteoroid

Thanks jdunkerley79!! That's worked perfectly now

 

Simple as removing a space and adding ToString

Labels