Discussion Board for collaboration related to QlikView App Development.
I have scenario to develop a query builder based on the database, table parameters.
vdatabasename, vTablename, vPrimarykey etc and based on these inputs we should be able to develop something which should generate the simple queries.
select count(*) from vdatabasename.vtablename
maybe with a loop on a table
// CONNECT ....
load * inline [
vdatabasename, vTablename, vPrimarykey
db1, tb1, pk1
db2, tb2, pk2
db3, tb3, pk3
FOR i=0 TO NoOfRows('d') -1
LET vdb=Peek('vdatabasename', $(i), 'd' );
LET vtb=Peek('vTablename', $(i), 'd' );
SET vsql1 = select count(*) from $(vdb).$(vtb) ;
SQL $(vsql1) ;
Thank you Grossi!!
I will test and let you know.
Thanks you Grossi! I was able to achieve the desired functionality with few modifications.