Can anyone help please?

[samvile18]

Good morning all,

I have an issue within my QV script that I'm hoping someone can help with.

I have the following table that I'm loading and I want to set the variable vGroupMisc to be the value that's returned in the GroupVariable field.

GroupVariable:

LOAD AppName,

          GroupName,

          GroupVariable

SQL SELECT *

FROM tblQVGroups

Where (AppName) = '$(vDocName)';

set vGroupName = ????

Can someone help?

[#2]

PEEK?

[samvile18]

Do you happen to know the syntax for the Peek function?

[samvile18 · Accepted solution]

I've figured this out using a combination of the above suggestion and the Lookup funtion.