${TABLE} is not allowed in the 'X' property. (Community)

View the original community article here

Last tested: Aug 29, 2019
 

If you get an e-mail with a schedule error and it says ${TABLE} is not allowed in the 'X' property, this because you are using ${TABLE} outside of a sql parameter.

Example of where this would fail:

dimension: test {

type: string

sql: ${TABLE}.field ;;

# The below html references are incorrect. Substitution operators (the ${}) can't be used in html because they evaluate to SQL.

html: My values are ${TABLE}.field and ${otherfield ;;

}

To fix this, use liquid references instead!

dimension: test {

type: string

sql: ${TABLE}.field ;;

# {{value}} is how you reference the value of this field, and {{viewname.fieldname._value}} is how you reference the values of other fields.

html: My values are {{value}} and {{otherfield._value}} ;;

}