Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hello,
Can you explain in detail what you are trying to achieve or what is the problem you are facing?
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
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
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