Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone
i want to join two tables with inner join on condition like table1.A=Table2.B ,i don't want to make the name of two column same
Hi
Try like this
Test:
LOAD * inline [
FieldA1, FieldA2, JoinFieldA
A,B,1
C,D,2
];
LOAD * Inline [
FieldB1,FieldB2,JoinField
W,X,1
Y,Z,3
] where Exists(JoinFieldA,JoinField);
But it does not have link between two tables.
Edit:
Second table load depends on first table data... not like inner join
It is impossible to join tables in Qlikview unless the tables have field names in common. The only way Qlikview can associate tables is on field names. So what you want is impossible. You could create another key field by using the autonumber or autonumberhashXXX functions.
Example:
TableA:
load A, C, D, E, autonumber(A) as %Key
TableB:
load B, F, G, autonumber(B) as %Key
Table A and B will now be associated on the new %Key field.