topic Join Cross Table in QlikView

Join Cross Table

Sat, 19 Feb 2011 07:50:43 GMT

Dear All,

Can we join cross table to other table ?. If so how to do it.

Thanks

Umesh

Join Cross Table

ivandrago — Sat, 19 Feb 2011 09:51:48 GMT

what databse are you pulling data from oracle, sql server?

AW:Join Cross Table

Sat, 19 Feb 2011 17:34:07 GMT

Hi Umesh,

I am not sure if I understand you correctly, what does prevent you from joining the resulttable from a Crosstable with another table? I'd do the crossload first and then the other table load with a preleading JOIN. Maybe you can post your example for further insight?

cheers

Florian

AW:Join Cross Table

prieper — Sun, 20 Feb 2011 21:00:35 GMT

You have to do the CROSSTABLE first, i.e. load it as temporary table and then join this tempory table - you cannot combine the JOIN with CROSSTABLE:

tempData: CROSSTABLE (Date, Data) LOAD * FROM ....;
JOIN (OtherTable) LOAD * RESIDENT tempData;
DROP TABLE tempData;

HTH
Peter

Join Cross Table

ali_hijazi — Fri, 08 Jul 2011 07:47:52 GMT

do you mean cross joining 2 tables inside a qlikview document?

if this is what you mean then if the 2 tables do not have matching fields then the join will do a cartesion product and gives you all combinations

table1:

load f1, f2

from source table;

join(table1)

load f3, f3

from sourcetable2;

AW:Join Cross Table

Wed, 22 Feb 2012 06:33:18 GMT

Dear Sir,

Can u plz tell how to join 2 crosstables.

Regards