Unknown Variable Formula Error

[Karl_Spratt]

Hi Community,

Can someone explain how I can fix this error?

Both the Country & route columns are coming into the W/F as V_String  

Example the route for a delivery in France would be FR-140, the Country Code would be FR so I'm saying if Route is populated pull the first 2 digits FR if empty ( no delivery created) pull the country code 

Can someone explain the fix here please. 

TIA,

Karl. 

[FinnCharlton]

Hi @Karl_Spratt ,

You are generating a new field called [Country], but also calling the [Country] field within the formula expression. A normal formula expression like this can't reference itself. You'll need to change your formula so it doesn't use the [Country] field - chances are you weren't meaning to call that field in the first place.

[Raj · Accepted solution]

Refer this link : hope this help

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Parse-Error-at-char-n-Unkno...