Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Concatenating loads from Excel files

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.

Tags (2)
4 Replies
hector
Valued Contributor

Concatenating loads from Excel files

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

rgds

Not applicable

Concatenating loads from Excel files

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$]);



Not applicable

Concatenating loads from Excel files

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

Not applicable

Concatenating loads from Excel files

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:







next

File;



Community Browser