Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Automatic Table Name when using * in reload script

Hi:

I was trying to load some excel file with part of the name are the same with each other.

So I use the wildcard * like follow:

Table:

LOAD

     [Field Name]...

FROM

[File Path\FileName*.xls]

(biff, embedded labels, table is Sheet1$);

The first excel file load in OK with the name Table as assigned.

But he rest of the excel load in a table with the name 'Table-1'.

How can I make all excel files load in to the same table with the name 'Table' ?

Thank you very much.

PC

Tags (2)
3 Replies
anbu1984
Honored Contributor III

Re: Automatic Table Name when using * in reload script

It should have created only one table

MVP
MVP

Re: Automatic Table Name when using * in reload script

Hi

For some reason there is a difference in the first loaded table's fields, and the fields in the subsequent tables. I suggest that you post your script, and if possible two of the excel files (just the first 5-10 lines) for further diagnosis. As the previous post said, they should have been auto-concatenated.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Automatic Table Name when using * in reload script

Hi Jonathan:

I found that the my first file is slightly different from the rest of the files.

All the fields in the LOAD session are available for all the excel files but the first file is an old version which means the order of the fields is different and some of the new fields are not included.

Do you think that could be the reason?

It it is, how can I make them into one table?

Thank you very much for your time.

Paco

Community Browser