Qlik Community

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
mluz
Partner - Contributor II
Partner - Contributor II

Data load script is executed without error, but data is not loaded

SET vLOOP = 11;

FOR i = 0 TO $(vLOOP)

// Variable para que recorra los ultimos 12 meses
LET vPeriodo = DATE(ADDMONTHS(TODAY(),-i), 'YYYYMM');

SET vFILENAME = '[C:\Proyecto Qlik\Proyecto Integrador\ARCHIVOS POR PERIODO\Detalle_Ordenes_$(vPeriodo).qvd]';

LET vFILESIZE = FILESIZE($(vFILENAME));

IF NOT IsNull(vFILESIZE) THEN

ORDENES_DETALLE_POR_PERIODO:
LOAD
*

FROM '[C:\Proyecto Qlik\Proyecto Integrador\ARCHIVOS POR PERIODO\Detalle_Ordenes_$(vPeriodo).qvd]'(qvd);

ENDIF

NEXT

3 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Try it in this way:

SET vLOOP = 11;

FOR i = 0 TO $(vLOOP)

// Variable para que recorra los ultimos 12 meses
LET vPeriodo = DATE(ADDMONTHS(TODAY(),-i), 'YYYYMM');

SET vFILENAME = C:\Proyecto Qlik\Proyecto Integrador\ARCHIVOS POR PERIODO\Detalle_Ordenes_$(vPeriodo).qvd;

LET vFILESIZE = FILESIZE('$(vFILENAME)');

IF NOT IsNull(vFILESIZE) THEN

ORDENES_DETALLE_POR_PERIODO:
LOAD
*

FROM [$(vFILENAME)](qvd);

ENDIF

NEXT

 

- Marcus

kiranpol
Contributor
Contributor

I surely that this will works for you. So please try it in this way:

SET vLOOP = 11;

FOR i = 0 TO $(vLOOP)

// Variable para que recorra los ultimos 12 meses
LET vPeriodo = DATE(ADDMONTHS(TODAY(),-i), 'YYYYMM');

SET vFILENAME = C:\Proyecto Qlik\Proyecto Integrador\ARCHIVOS POR PERIODO\Detalle_Ordenes_$(vPeriodo).qvd;

LET vFILESIZE = FILESIZE('$(vFILENAME)');

IF NOT IsNull(vFILESIZE) THEN

ORDENES_DETALLE_POR_PERIODO:
LOAD
*
omegle
FROM [$(vFILENAME)](qvd);
cps test
ENDIF

NEXT

Regards

KiranPol

Jill_Masinde
Support
Support

@mluz 

Did the suggestion solution help resolve this issue for you?  Your feedback is important to us.  Kindly respond by marking the Accept as Solution.

Thanks