- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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