topic Re: Automatic Table Name when using * in reload script in QlikView

Automatic Table Name when using * in reload script

Tue, 02 Dec 2014 04:56:39 GMT

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.

Re: Automatic Table Name when using * in reload script

anbu1984 — Tue, 02 Dec 2014 05:44:40 GMT

It should have created only one table

Re: Automatic Table Name when using * in reload script

jonathandienst — Tue, 02 Dec 2014 06:05:17 GMT

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

Re: Automatic Table Name when using * in reload script

Tue, 02 Dec 2014 22:24:24 GMT

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