Crosstable resident load

[#1]

Hi,

got somewhat of a brainfreeze. Anyone sees why the below script results in no table when run?

INITIAL:

CrossTable(Month, Data)
LOAD [Type],
     [201206],
     [201207],
     [201208],
     [201209],
     [201210],
     [201211],
     [201212],
     [201301]
FROM

(ooxml, embedded labels, header is 2 lines, table is Data);

FINAL:
Load *
Resident INITIAL
where Data>10;
Drop table INITIAL

[vikasmahajan]

hiii,

attach hej.xlsx for checking

vikas

[rubenmarin · Accepted solution]

Hi Olle, I see two possibilities:

1.- There is no Data>10 in  INITIAL table.

2.- The FINAL table is autoconcatenated in INITIAL table and then dropped, add 'Noconcatenate' clause:

FINAL:
NoConcatenate Load *
Resident INITIAL
where Data>10;
Drop table INITIAL

[sunny_talwar]

I think it must be the second one. NoConcatenate should solve the problem.

[#5]

It was the second one, thanks!!