Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ngreddy1982
Contributor III
Contributor III

QVD help - sql

I am trying to join 4QVDs ,

1 : table I have internet orders and reason code for return ,

2 : I have internet orders and delivery company used ,

3 I have order number and country shipped to

4 I have order number and weight.

Can you please help me to get them all to one table .

1 Solution

Accepted Solutions
ganeshsvm
Creator II
Creator II

Hi, You may try like this,

Table1:

LOAD Field1,

           Field2,.......

FROM (filepath);

Join(Table1)

Table2:

LOAD Field1,

           Field2,.......

FROM (filepath);

Join(Table1)

Table3:

LOAD Field1,

           Field2,.......

FROM (filepath);

Join(Table1)

Table4:

LOAD Field1,

           Field2,.......

FROM (filepath);

Note: Based on the logic for your table relationship, you have to use joins(LEFT, RIGHT, INNER, OUTER)

Follow these links for more info about joins in QlikView

Hope this helps,

-Ganesh

View solution in original post

7 Replies
MarcoWedel


please don't post the same question multiple times:

Query help please


some sample lines from each of your tables and your expected result might help to find a solution.


thanks


regards


Marco

ngreddy1982
Contributor III
Contributor III
Author

Sorry , but no one had answered , I was looking for help.

Anonymous
Not applicable

you need SQL query with join or Qlik load statements?

select orderID, reason, delivery_company, country_shipped , weight from Table 1 a inner join table 2 b

on  a.orderid=b.orderid inner join table 3 on a.orderid=c.orderid  inner join table 4 d on a.orderid=d.orderid

Anonymous
Not applicable

Can you please share some screen shot ....

sumit_ranjan_pa
Former Employee
Former Employee

Hi Giridhar,

QlikView by default uses associative  model to connect data . That means if two table have similar similar data and field name they will be associated and selection in one table will be reflected in another.  Explicit join is not something used really often when not needed or if you have really large data model. 

Please provide some more details on the query required.

Thanks and regards,

Sumit

stonecold111
Creator III
Creator III

Use join condition based on common columns

they all come in one table

ganeshsvm
Creator II
Creator II

Hi, You may try like this,

Table1:

LOAD Field1,

           Field2,.......

FROM (filepath);

Join(Table1)

Table2:

LOAD Field1,

           Field2,.......

FROM (filepath);

Join(Table1)

Table3:

LOAD Field1,

           Field2,.......

FROM (filepath);

Join(Table1)

Table4:

LOAD Field1,

           Field2,.......

FROM (filepath);

Note: Based on the logic for your table relationship, you have to use joins(LEFT, RIGHT, INNER, OUTER)

Follow these links for more info about joins in QlikView

Hope this helps,

-Ganesh