topic looping though files and table names in QlikView

looping though files and table names

amien — Thu, 10 Feb 2011 20:45:09 GMT

i want to loop though all the files, but keep the tables names.

now, table names are renamed to table-1, table-2 etc.

now can i do this? i also tested with for each File in filelist.

same result

looping though files and table names

Thu, 10 Feb 2011 20:52:49 GMT

Hello,

Can you explain in detail what you are trying to achieve or what is the problem you are facing?

looping though files and table names

amien — Thu, 10 Feb 2011 21:01:41 GMT

in 1 excel file i read 3 sheets. All sheets contains fact data, so i concatenate them to 1 table.

this works fine.

but now i want to read more excel files using *.xls or for each file solutions.

all files well be read, but each file gets its own fact table (FACT, FACT-1, FACT-2) ... Qlikview renames those table names. i want 1 fact table redardless how many files is loop though

looping though files and table names

Thu, 10 Feb 2011 21:07:34 GMT

If I understood correctly what you are trying to do, after you concatenate write the Resident statement and then use the Drop Table function. THis way all your data will be in one flat table with one name.

Else you may attach a sample QVW and then it will be helpful

Mama

looping though files and table names

Fri, 11 Feb 2011 08:04:05 GMT

Hi,

You can do some workarount like creating an empty fact table with same structure through inline load before starting the loop and inside the loop before the load statement use concatenate keyword.

May be this will help you,

Thanks & Best Regards,

Kuldeep Tak