topic join problem in QlikView

join problem

Tue, 18 Aug 2009 18:28:41 GMT

Hi *,

my 'code'

Order:
LOAD * INLINE [
OID, Article, CID
1, 23442,1
2, 55321,2
3, 31331,2
4, 41536,3

];

Customer:
LOAD * INLINE [
CID, Name, Prename
1, Jones, Henry
2, Presley, Elvis
3, Fogerty, John
];

JTable:
Load
OID,
Article,
CID
Resident Order;

Join (JTable)
Load
CID,
Name,
Prename
Resident Customers;

//Drop Table Order;
//Drop Table Customer;

Unfortunately this isn't working. Can someone help me with this?

join problem

stephencredmond — Tue, 18 Aug 2009 18:40:16 GMT

Easier to do it this way?:


Order:
LOAD * INLINE [
 OID, Article, CID
 1, 23442,1
 2, 55321,2
 3, 31331,2
 4, 41536,3
];
Join LOAD * INLINE [
 CID, Name, Prename
 1, Jones, Henry
 2, Presley, Elvis
 3, Fogerty, John
];

Regards,

Stephen

join problem

Anonymous — Wed, 19 Aug 2009 09:36:21 GMT

Stephen's answer is quite correct. and, the simpler the script - less errors... I only want to explain why the code is "not working".
This part does not create new JTable because the field names are exactly the same as in Order table.


JTable:
Load
 OID,
 Article,
 CID
Resident Order;

Instead it is autoconcatenated with the Order table. And, later you drop Order. an get nothing.