Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
hlines_usacs
Creator II
Creator II

Using Variable in Load Script WHERE clause

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:

load script 1.jpg

Throws error:

load script 2.jpg

1 Solution

Accepted Solutions
shivanandk
Partner - Creator II
Partner - Creator II

Try:

WHERE APP_FLAG = '$(vAPPFlag)'

View solution in original post

3 Replies
shivanandk
Partner - Creator II
Partner - Creator II

Try:

WHERE APP_FLAG = '$(vAPPFlag)'

danielrogra
Creator
Creator

Hi Hannah

Have you tried using '$(vAPPFlag)'?

Regards

hlines_usacs
Creator II
Creator II
Author

perfect! thanks so much!