topic Re: Script help in QlikView

Script help

Anonymous — Wed, 08 Apr 2015 16:19:54 GMT

LET vDate=today();
LET vDateNow=Now();
set vtesttable= Q:\d771\F88776\SHARED\CompanyRead\Network Informatics\Special Projects\John Mingus\Qlikview\Monthly Reports\test;

ODBC CONNECT32 TO PIMS (XUserId is MYIcPVBPNLMKDbMGLC, XPassword is dRAXPaBNSLaMXSNEQZHB);

Test:
sql
SELECT TOP 10 [prdtKey]

      ,[enrollTypeCd]
      ,[termDt]
     FROM [ProvInfoRpt].[dbo].[dcPrdt];

store Test into $(vtesttable).qvd;
drop table Test;

export:
load
,[enrollTypeCd]
,[termDt]

from $(vtesttable).qvd

Can someone help be with the scrip above,? Assuming there are multiple errors in the script but I cannot get the script to load corerctly. Any help would help.

Re: Script help

sunny_talwar — Wed, 08 Apr 2015 16:32:25 GMT

Is there a reason that you are first storing your table into a qvd and then recalling the same qvd after dropping the first table?

Best,

Sunny

Re: Script help

rajkumarb — Wed, 08 Apr 2015 16:33:34 GMT

Hi John

Try Like this

Test:

load
,[enrollTypeCd]
,[termDt]

sql
SELECT TOP 10 [prdtKey]

      ,[enrollTypeCd]
      ,[termDt]
     FROM [ProvInfoRpt].[dbo].[dcPrdt];

store Test into $(vtesttable).qvd;
drop table Test;

export:
load
,[enrollTypeCd]
,[termDt]

from $(vtesttable).qvd

Re: Script help

Wed, 08 Apr 2015 16:43:38 GMT

Hi MrJohn23,

this can work, there were some errors in your script

LET vDate=today();
LET vDateNow=Now();
set vtesttable= 'Q:\d771\F88776\SHARED\CompanyRead\Network Informatics\Special Projects\John Mingus\Qlikview\Monthly Reports\test';

ODBC CONNECT32 TO PIMS (XUserId is MYIcPVBPNLMKDbMGLC, XPassword is dRAXPaBNSLaMXSNEQZHB);

Test:
sql
SELECT TOP 10 [prdtKey]
      ,[enrollTypeCd]
      ,[termDt]
     FROM [ProvInfoRpt].[dbo].[dcPrdt];

store Test into $(vtesttable).qvd (QVD);
drop table Test;

export:
load
[enrollTypeCd] ,
[termDt]
from $(vtesttable).qvd (QVD);

Regards

Re: Script help

Wed, 08 Apr 2015 17:46:08 GMT

1. Add single quote (' ') for vtesttable variable (ex: set vA='Name'; )

2. Please remove comma (, ) in export table after Load statement. Reload the script after modification.

Re: Script help

Anonymous — Wed, 08 Apr 2015 18:30:57 GMT

This is a subset of a bigger app and I'm trying to create the script is the most sufficient way. I originally used"Resident" to refer to the original table but was told that storing and refering to QVDs is more effective.

Re: Script help

sunny_talwar — Wed, 08 Apr 2015 18:38:04 GMT

Oh really? I would really like to get more details on this topic. Thanks for responding back

Best,

Sunny

Re: Script help

Anonymous — Wed, 08 Apr 2015 18:42:23 GMT

Just trying to learn best possible soultions as I know very little about Qlikview, that's why I come to you guys to set me straight.