Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
Yes u just Concate the field
select (Column1,Column2) as Composite Key,Data1
from Table1;
select (Column1,Column2) as Composite Key,Data2
from Table2;
after that use join
select a.Composite Key,b.composite key, Data1, Data2
from Table1 a left join Table2 b
where a.Composite=b.Composite;