In my data model I am taking several qvd files created in my extract, and loading them into the same table. For some reason qlikview is creating a separate table for each qvd rather than just concatenating them onto each other. Is there a keyword that I can use in the code shown to prevent qlikview from creating multiple tables for each qvd? Thanks.
I think your problem should be a little better described.
One cause could be that tables dont have the same structure (field names and types...).
I dont know how exactly this way of loading with a star in file path works, but you can try different way. Try with a loop, lists all the files, save them in a variable and then in a loop load data from these qvd-s. (just my proposal)
According to the rules, should QV automaticly concetane this tables, if the format of the tables match.