issue while Loading data from multiple source

[#1]

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;

[alexandros17]

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)