Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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
please don't post the same question multiple times:
some sample lines from each of your tables and your expected result might help to find a solution.
thanks
regards
Marco
Sorry , but no one had answered , I was looking for help.
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
Can you please share some screen shot ....
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
Use join condition based on common columns
they all come in one table
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