This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Something changed in the metadata, and the field/ column [variable_name] is no longer available, i.e.: the variable being used to create a formula is missing or has not yet been created.
Breaking down the error message, Parse Error at char (6) tells you exactly where the issue is: it starts at the sixth character in (Expression #1). Remembering that Alteryx Designer is 0-based, start counting at zero.
Designer uses brackets to identify variables, therefore, in the formula [x1]+[x2], the sixth character is the x at the beginning of variable [x2] which is the variable in question. Another hint is that the text color of variable [x2] is black, indicating that it is not a recognized variable name.
From here, trace backwards from the erroring tool to find out where the column went “missing.” For example, [variable_name] may have been renamed in a Select tool upstream or deselected in an intermediate tool.
When building a formula or using functions, verify that all string values are in quotes. Ensure variable names doesn't have leading or trailing spaces, [ variable_name] or [variable_name ]. Do not use brackets in variable names. These types of errors are especially common in nested conditional statements.