Using Variable in Load Script WHERE clause

[hlines_usacs]

Hello, hopefully this is an easy one. I just can't figure out the correct syntax. Below are two screen shots; the first one loads without error, but the second does not. Does anyone know the correct syntax for using this variable to filter data?

Run successfully:

Throws error:

[shivanandk · Accepted solution]

Try:

WHERE APP_FLAG = '$(vAPPFlag)'

[danielrogra]

Hi Hannah

Have you tried using '$(vAPPFlag)'?

Regards

[hlines_usacs]

perfect! thanks so much!