topic Help with some tricky join for two tables in QlikView

Help with some tricky join for two tables

Wed, 16 Feb 2011 07:40:35 GMT

Hi dear all!

I need to make some tricky join with qlikview for two tables.

1. table has one field with ID in column like:

111

222

2.table has same ID's in two columns in a row like:

ID ID2

111 222

How to correctly join this tables ?

Thanks!

deepakk — Wed, 16 Feb 2011 07:44:40 GMT

hi,

I would suggest you to use the crosstable method on the second table so now you data might look like

Id_Data ID

ID 111

ID2 222

Now link the ID field with the above table.

Wed, 16 Feb 2011 07:46:26 GMT

HI USe the cross table for the above problem.

Wed, 16 Feb 2011 07:47:02 GMT

Is it possible for SQL tables ?

Wed, 16 Feb 2011 07:50:45 GMT

Yes it is possible...... when you select you table ......

Do next > enable transform > next > cross table

deepakk — Wed, 16 Feb 2011 08:12:47 GMT

hi,

If you are not comfortable in doing it SQL you can do it using resident.

eg :

test:

Select * from table;

crosstable(ID_field, ID, 2)

load

fieldnames....

resident test;

Wed, 16 Feb 2011 13:21:03 GMT

Thanks to all. Crosstable solved the problem.

Big thanks!