topic Re: Crosstable resident load in QlikView

Crosstable resident load

Tue, 28 Jul 2015 11:59:40 GMT

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

Re: Crosstable resident load

vikasmahajan — Tue, 28 Jul 2015 12:11:28 GMT

hiii,

attach hej.xlsx for checking

vikas

Re: Crosstable resident load

rubenmarin — Tue, 28 Jul 2015 12:12:58 GMT

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

Re: Crosstable resident load

sunny_talwar — Tue, 28 Jul 2015 12:14:06 GMT

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

Re: Crosstable resident load

Tue, 28 Jul 2015 12:23:38 GMT

It was the second one, thanks!!