Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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 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

2 Replies
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

Thanks & Regards,
Mayil Vahanan R
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.


talk is cheap, supply exceeds demand