Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
====================================================================
Hi,
Try like this
// 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 vFileType = '(qvd)';
SET vDQ_FileNameSource ='$(vDQ_PathSource)$(vDQ_FileNameVal)$(vFileFormat)$(vFileType)';
Extract:
LOAD *
FROM $(vDQ_FileNameSource);
Regards,
Jagan.
Hi
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
Hi,
Try like this
// 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 vFileType = '(qvd)';
SET vDQ_FileNameSource ='$(vDQ_PathSource)$(vDQ_FileNameVal)$(vFileFormat)$(vFileType)';
Extract:
LOAD *
FROM $(vDQ_FileNameSource);
Regards,
Jagan.
Thanks very much Jagan, that was the solution!
I just overlooked that (qvd) qualifier.
Rob.