If statement not evaluating to true when comparing a model

Help
1

Hello

I am trying to create a sql template using a macro with one parameter, the if condition does not evaluate to true when passed TABLE1 or TABLE2

{% macro cloud_test_results_get_standard_columns(modelName) %}
result,
Length,
estimatedLength as estimatedLength,
{% if ‘{{modelName}}’ == ‘TABLE1’ %}
TABL1_COL1,
TABL1_COL1,
TABL1_COL1,
{% elif ‘{{modelName}}’ == ‘TABLE2’ %}
TABL1_COL1,
TABL1_COL1,
TABL1_COL1,
{% else %}
TABL_DEFAULT1,
TABL_DEFAULT2,
TABL_DEFAULT3,
{% endif %}
{% endmacro %}

2

please disregard, had to use modelName instead of ‘{{modelName}}’ inside if block

3

Yes you got it! When you’re inside of curly braces, you don’t need another set of curlies around your variables.

Related docs:

4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.