issue while Loading data from multiple source

Thu, 31 Jan 2013 16:02:20 GMT

HI All,

I need your expert advice on the below code.

I have two excel files which contains the data for Current and Next quarter. the below working code gives all the result from both the files.

but if i Remove the "CrossTable(FundName, FundData, 97)" and try to load, it gives me only one quarter data.

WORKING CODE:

FOR each File in filelist ('C:\Users\mishsubh\Desktop\Q2C\TEST\Input\*.xlsx')

CrossTable(FundName, FundData, 97)

ActivityNew:

LOAD *

FROM [$(File)] (ooxml, embedded labels)

Where [Activity Status]<>'NoFund' and [Activity Status]<>'Pending' and [Activity Status]<>'Cancelled' and [Activity Status]<>'Rejected' ;

NEXT File ;

Store ActivityNew into C:\Users\mishsubh\Desktop\Q2C\TEST\ActivityNew.Qvd;

Drop table ActivityNew;

Re: issue while Loading data from multiple source

alexandros17 — Thu, 31 Jan 2013 16:30:52 GMT

When you use a crossatble instruction, data on columns are translated in rows, deleting that keyworld you are reading data ina wrong way (in a way your chart are non prepared to)

topic issue while Loading data from multiple source in QlikView

issue while Loading data from multiple source

Re: issue while Loading data from multiple source