topic Re: Join five qvds in Connectivity & Data Prep

Join five qvds

denisetrujillo — Fri, 31 Jul 2020 18:28:56 GMT

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

Re: Join five qvds

ArnadoSandoval — Tue, 04 Aug 2020 05:34:15 GMT

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

Re: Join five qvds

denisetrujillo — Tue, 04 Aug 2020 14:15:05 GMT

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.

Re: Join five qvds

Kushal_Chawda — Tue, 04 Aug 2020 14:35:35 GMT

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;

Re: Join five qvds

ArnadoSandoval — Wed, 05 Aug 2020 01:56:01 GMT

Thanks @denisetrujillo

Kush solution is the way to go!

hth