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

Question

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 Answer

@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  ..............