Help with some tricky join for two tables

[#1]

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:

ID

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]

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.

[#3]

HI USe the cross table for the above problem.

[#4]

Is it possible for SQL tables ?

[#5]

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

Do next > enable transform > next > cross table

[deepakk]

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;

[#7]

Thanks to all. Crosstable solved the problem.

Big thanks!