Error: type mismatch: string provided where a number is required

[SKRJALA1]

Hi,

I am trying to use a parse formula using if conditionals and left function and I am getting the error "type mismatch: string provided where a number is required"

Both "reference" field and new output column are set to V_WString. What am I missing? Thanks!

[binu_acs · Accepted solution]

@SKRJALA1  the syntax of the Left function is given below

https://help.alteryx.com/20221/designer/string-functions

in your use case use the Contains function

If Contains([Reference],'KBMAS') Then 'Sloania' 

ElseIF  ..............

[SKRJALA1]

Thanks!