Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
HI USe the cross table for the above problem.
Is it possible for SQL tables ?
Yes it is possible...... when you select you table ......
Do next > enable transform > next > cross table
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;
Thanks to all. Crosstable solved the problem.
Big thanks!