Hello Everyone

Wed, 22 Sep 2010 23:26:01 GMT

Can any one give me clear idea about joins in Qlikview modelling part please..

Any Video Links or DATA links Will be Appriciated,Thank you

regard's

shiva...

johnw — Wed, 22 Sep 2010 23:41:24 GMT

I don't really have any video or data links. But:

A:
LOAD * INLINE [
ID, Field1
1, 123
2, 456
3, 789
];
LEFT JOIN (A)
LOAD * INLINE [
ID, Field2
1, A
2, B
4, C
];

This LEFT join will generate:

ID, Field1, Field2
1, 123, A
2, 456, B
3, 789,

A RIGHT join would generate:

ID, Field1, Field2
1, 123, A
2, 456, B
4, , C

An INNER join would generate:

ID, Field1, Field2
1, 123, A
2, 456, B

An OUTER join would generate

ID, Field1, Field2
1, 123, A
2, 456, B
3, 789,
4, , C

A CONCATENATE would generate:

ID, Field1, Field2
1, 123,
2, 456,
3, 789,
1, , A
2, , B
4, , C

Hopefully I got all of those right.

topic Hello Everyone in QlikView