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

[#1]

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

[MayilVahanan]

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

[Gysbert_Wassenaar]

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.