Script help

[Anonymous]

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.

[sunny_talwar]

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

[rajkumarb]

Hi John

Try Like this

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:

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

[#4 · Accepted solution]

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

[#5]

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.

[Anonymous]

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.

[sunny_talwar]

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

Best,

Sunny

[Anonymous]

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.