how to execute the Select statement stored in variable?

Tue, 04 Sep 2012 10:43:29 GMT

I have a table where I've stored the queries.

Table SQL_QUERY

ID, QUERY
1,SELECT * FROM EMPLOYEE
2,SELECT * FROM DEPARTMENT

//Now I am Looping this table -
for vLoopNumber = 1 to NoOfRows('SQL_QUERY')
Let vSQL = FieldValue('SQL_QUERY',$(vLoopNumber)); // it fetches the Query

// Now I want to load the FieldValue('SQL_QUERY',$(vLoopNumber)) i.e resultset of query in table.

Table:
LOAD *;
vSQL ; // here I want to execute the Select statement stored in variable vSQL.

Next vLoopNumber

---
Please let me know how to execute the Select statement stored in variable vSQL.

Regards
Nilesh

Re: how to execute the Select statement stored in variable?

whiteline — Tue, 04 Sep 2012 10:50:58 GMT

Try $(vSQL) instead of vSQL ;

Re: how to execute the Select statement stored in variable?

Tue, 04 Sep 2012 11:01:55 GMT

Thank you very much!

Regards

Nilesh

topic Re: how to execute the Select statement stored in variable? in QlikView

how to execute the Select statement stored in variable?

Re: how to execute the Select statement stored in variable?

Re: how to execute the Select statement stored in variable?