Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In RDBMS, we can specify which columns we want to join on. Can we do the same in Qlikview 11 ?
Eg. consider some "logical tables" - Table1(Field1, Field2, Field3), Table2(Field7, Field8, Field9)
SQL -
Select *
from Table1 as t1
left join Table2 as t2
on t1.Field1 = t2.Field9
and t1.Field2 = (t2.Field7 + 1)
Here, we do NOT want to join on Field3 and Field9.
Can Qlikview do something similar as imagined below ?
[t1]:
LOAD
Field1, Field2, Field3
FROM [your CSV file];
//[t2]:
LEFT JOIN ([t1])
LOAD
Field7, Field8, Field9
FROM [Your CSV file]
on t1.Field1 = t2.Field9
and t1.Field2 = (t2.Field7 + 1)
Hi John,
In qlikview the tables automatically join if column names are same, try like this
[t1]:
LOAD
Field1, Field2, Field3
FROM [your CSV file];
//[t2]:
LEFT JOIN ([t1])
LOAD
Field7 + 1 AS Field2,
Field7,
Field8,
Field9 as Field1,
Field9
FROM [Your CSV file];
Hope this helps you.
Regards,
Jagan.
Hi John,
In qlikview the tables automatically join if column names are same, try like this
[t1]:
LOAD
Field1, Field2, Field3
FROM [your CSV file];
//[t2]:
LEFT JOIN ([t1])
LOAD
Field7 + 1 AS Field2,
Field7,
Field8,
Field9 as Field1,
Field9
FROM [Your CSV file];
Hope this helps you.
Regards,
Jagan.