Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi !
I'm trying to get the simple table from CrossTable. Source document - Excel, at each Tab single crosstable. Name of Tab in format "YYYYMM".
I've got the weight coefficients on every tab by dates of outlets. If the data exists all is OK. If i there is no eny weights - CrossTable doesn't works. But i need the key information on the tabs which not includes any weights - it's the list of dates and outlets.
I'm trying to use NULLASVALUE with SET of null variable, but it doesn't yield any result...
Some peace of code:
LET vFezPrev = 201301;
LET vFezCur = 201412;
IF Alt(FileSize('$(vFile)'),0)>0 then
FOR vFez = vFezPrev to vFezCur
LET ErrorMode=0;
CALL DropTables('tmpData');
tmpData:
CrossTable(Date, Weight, 3)
LOAD
*
FROM
[$(vFile)]
(ooxml, embedded labels, table is [$(vFez)]);
LET vtmpFile = '$(vPathXLSDest)\$(vPrefixXLS2)_$(vFez).qvd';
EXECUTE cmd.exe /C del /Q $(vtmpFile);
STORE tmpData INTO [$(vtmpFile)](qvd);
LET ErrorMode=1;
NEXT
ELSE
TRACE NO DATA;
ENDIF
Hope for yours help.
Thnx.
Within a crosstable-load you couldn't really check and/or change any data. Therefore make at first a ordinary load and use crosstable as second step.
- Marcus
Within a crosstable-load you couldn't really check and/or change any data. Therefore make at first a ordinary load and use crosstable as second step.
- Marcus