Join five qvds

[denisetrujillo]

Good day,

I ask for your help to know if someone counts or can help me in knowing how to create a subroutine that allows me to join five qvd and later join the information of all those qvd.

@Michael_Tarallo 

[ArnadoSandoval]

Hi @denisetrujillo 

I understand you have 5 QVDs, what do they represent? Customers, Products, Sales Transactions, and so on; it will help us to help you when we know more about the objects involved in your questions; also, would it be possible to include the fields or columns names of these QVDs, with that sort of information we may guide you better.

hth

[denisetrujillo]

each qvd belongs to the database of different companies, they all contain the same tables.
what I require is to join the information, I use "concatenate", but I don't want to use it because there are more than ten qvd.

company1.qvd
company2.qvd
company3.qvd
company4.qvd

I require to know the sales of the union of all the companies. 
Inside the qvd I have information about products, clients, sales,  etc.

[Kushal_Chawda · Accepted solution]

If all your QVD is having same structure with same field name then you can simply use wildcard to load all tables at once

Data:

load *

FROM Company*.qvd;

[ArnadoSandoval]

Thanks @denisetrujillo 

Kush solution is the way to go!

hth