topic Concatenating loads from Excel files in QlikView

Concatenating loads from Excel files

Wed, 14 Jul 2010 19:34:27 GMT

All,

Maybe this might have been asked/answered before, but here's the issue I'm having :

Table:

LOAD

FROM Folder\Name-*.xls

does not seem to concatenate the excel files while I have seen similar code work in concatenating *.qvd files. With the above code, the data goes into a new table for each file.

Any ideas on what/how I could change the code for concatenation? Thanks.

-Sandy.

Concatenating loads from Excel files

hector — Wed, 14 Jul 2010 19:54:13 GMT

Hi, you forgot mention the Sheet on the load statement, is this just an example?

rgds

Concatenating loads from Excel files

Wed, 14 Jul 2010 19:58:31 GMT

Yup, this is just an example. In my code I do have the sheet name :

from

[Folder\File.xls] (biff, embedded labels, table is [Summary$]);

Concatenating loads from Excel files

Wed, 14 Jul 2010 22:57:53 GMT

are there an identical number of columns, and are they named the same? -- they need to be for QV to auto-concatenate.

Concatenating loads from Excel files

Thu, 15 Jul 2010 14:20:18 GMT

Ryan,

Yes they are. I managed to get the concatenation to work by simply using :

FOR EACH file in filelist and then,

placing a CONCATENATE before the LOAD statement

But I find that the data is not loaded into the table (Report) that I specified. Here's the example code :

for

CONCATENATE

LOAD subfield(filebasename(),'.',2) as Date,

'Weekly'

as ReportType,

Description

Tdata,

Volume,

NVolume

Tdata2

Vol2

NV2

FROM

[$(File)] (biff, embedded labels, table is [Summary$] );each File in filelist (FolderName&'Report.*.W.xls')

Report:

File;