Re: I have about 100 QVD files is it there a way to simplify loading process
This is why enumerating around a number of files hardly ever works. There is almost always things you need to do to each file as you load it.
You could use the qualify and unqualify statements to manage how joins happen - as you are in your uploaded example.
It also sounds like you need to put another tier of loading in, to merge your first level QVDs into a second more structured level of QVDs - perhaps merging data from multiple QVDs using ApplyMap, Concatenate and JOIN.
I've a blog post on ApplyMap that you may find helpful: