Best way to read excel sheet with many tab ?

[#1]

Hi All

I have a excel file as per enclosed. I like to ask in order for me to read the raw data into QV ,there must be best approach. hope some one can advise me.

Instead of i read individual Tab one by one which is very trouble some , it there a better approach on short cut ?

Paul

[salto]

Hello,

I have just attached the corrected script. I have just corrected the line that was wrong.

Please check and let me know.

Regards!

[#3]

Hi Salto

I notice that when i try to load in more table it get problem because sync key generated , this is due to lack of concatenate.

Any way you know where to place the concatenate command to which part of the script ?

As i notice that your script is more user-friendly. easy to understand.

Paul

[#4]

Hi Paul,

Sync Key will be generated if eg in two tables there is more than one linkage happening.

Qlikview by default tends to internally join them.

In your case, if you use concatenate ,for all the tabs/sheets present in your XL file,you will have to use the same column names and define the same unique key for every tab/sheet and link it with your data model,else you will face this synthetic key problem

Hope this Helps.

Rochelle

[salto]

Hello Paul,

    John is right, you should rename the headers to the same values, something like:

No

Date

Ref. No

Customer

Quot items

Qty

Quot amount

Status

Regards.

[#6]

Hi sir

Thank for your feedback on sync key. As i compare your script with the other which is working. My table for last 12 month all the field are not the same. And some how it able to read in with out any issue. So i think must be due to other script are more.powerful.

Paul

Sent from Samsung Mobile

[#7]

Hi Salto

But the point is their another script given to me i never rename it work juat fine. Hope you can share with me why. So i also learn from here.

Sent from Samsung Mobile

[salto]

Hi Paul,

The loop makes the script look always for the same field names.

You could concatenate the loop so it does not create the sync keys, but check that the results are correct!

AllData:

concatenate

LOAD *

FROM

[quotation list  2013.xlsx]

(ooxml, embedded labels, table is $(vSheet));

next i

Regards

[#9]

Hi Salto

Thank you very much for your help , now the table look nice and all field go into one table.

This is what i want.  Now your script is much better.

Paul