topic Re: Load table based on parameter not working... in QlikView

Load table based on parameter not working...

Tue, 27 May 2014 08:25:53 GMT

Hello,

I would like to load a table based on parameters.
In a next step i like to automate the load proces for more tables.

After reloading this script i only get to see: "<?xml version="1.0" encoding="UTF-8" standalone="yes"?>"

Can anyone please help me with this? What did i do wrong?

Rob.

===================================================================

SET ThousandSep='.';
SET DecimalSep=',';

SET MoneyThousandSep='.';
SET MoneyDecimalSep=',';
SET MoneyFormat='€ #.##0,00;€ -#.##0,00';
SET TimeFormat='h:mm:ss';
SET DateFormat='D-M-YYYY';
SET TimestampFormat='D-M-YYYY h:mm:ss[.fff]';
SET MonthNames='jan;feb;mrt;apr;mei;jun;jul;aug;sep;okt;nov;dec';
SET DayNames='ma;di;wo;do;vr;za;zo';

// Fill in table name:
SET vFileNameVal              ='NAV_Customers';
// Automated additions:
SET vDQ_PathSource         ='\\QV-01\Development\Data\2_Stage_QVDs\';
SET vDQ_FileNameVal       ='DQ_$(vFileNameVal)';
SET vFileFormat                  ='.qvd';
SET vDQ_FileNameSource ='$(vDQ_PathSource)$(vDQ_FileNameVal)$(vFileFormat)';

Extract:
LOAD *
FROM $(vDQ_FileNameSource);
//FROM [\\QV-01\Development\Data\2_Stage_QVDs\DQ_NAV_Customers.qvd] (qvd);

====================================================================

Re: Load table based on parameter not working...

jonathandienst — Tue, 27 May 2014 08:40:59 GMT

You appear to have commented out the (qvd) type qualifier, so it is trying to load as a text file. Just move the (qvd) to before the ; closing the load statement.

HTH

Jonathan

Re: Load table based on parameter not working...

jagan — Tue, 27 May 2014 09:00:45 GMT

Hi,

Try like this

SET vFileType = '(qvd)';
SET vDQ_FileNameSource ='$(vDQ_PathSource)$(vDQ_FileNameVal)$(vFileFormat)$(vFileType)';

Extract:
LOAD *
FROM $(vDQ_FileNameSource);

Regards,

Jagan.

Re: Load table based on parameter not working...

Tue, 27 May 2014 09:13:52 GMT

Thanks very much Jagan, that was the solution!

I just overlooked that (qvd) qualifier.

Rob.