topic Re: loading tables in QlikView

loading tables

prabhas277 — Wed, 09 Sep 2015 04:42:13 GMT

Hi experts,

for example i have 50 excel sheets now i want load 20 sheets from the 50 sheets.now my req is i want load 10-15 shhets,20-25 and 30-35 and 45 to 50 how i can get it?

Re: loading tables

tresB — Wed, 09 Sep 2015 04:55:45 GMT

Some good discussion links are here: Re: Import multiple sheets in excel

Re: loading tables

sujeetsingh — Wed, 09 Sep 2015 04:57:06 GMT

what you need is still not clear?

Well you can write codes to load sheets with a number added to the name of sheet and then use these numbers for sorting and loading.

Re: loading tables

kuczynska — Wed, 09 Sep 2015 07:57:51 GMT

You can create subroutine and load your tables in the loop, considering some conditions (like validating the excel sheet numbers).

Re: loading tables

krishna20 — Wed, 09 Sep 2015 10:39:10 GMT

Hi,

This may helps you,

Load Multiple excel sheets using For loop