Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table-1 with say, ID-1, name ,place and table-2 with ID-2.
How do i apply the query,
select * from Table-1 where ID-1 in (ID-2)
please help , its very urgent.
TAB_TMP:
LOAD ID-2 as myID Resident Table-2;
TAB:
noconcatenate
LOAD * Resident Table-1 where exists(myID, ID-1);
let me know
Should be:
select * from Table-1 as t1 inner join select * from Table-2 as t2 on t1.ID-1 = t2.ID-2
let me know
Er... but those tables are in the database or in QlikView already?
If they are in QlikView, then:
Load *
Resident [table-1]
Where Exists([ID-2],[ID-1])
;
should do it.
If the tables have the same key field, you could use Keep as well.
Hi,
Simple Left join also work for you
load ID-2 as ID-1 from table2;
left join
load ID-1, name ,place from table1;
Regards
Hi,
I assume tables are in Qlikview.
Try:
Load *
Resident Data
Where [ID-1]) = [ID-2];
OR
Load *
Resident Data
Where Exists([ID-1],([ID-2]);
Hope it helps.
Regards
Neetha
hi Alessandro, I need to apply the logic in qlikview script.
TAB_TMP:
LOAD ID-2 as myID Resident Table-2;
TAB:
noconcatenate
LOAD * Resident Table-1 where exists(myID, ID-1);
let me know
This gives error for col"ID-2".-" field not found"
Hi,
Try:
Load *
Resident Data
Where [ID-1] = [ID-2];
OR
Load *
Resident Data
Where Exists([ID-1],[ID-2]);
Hope it helps.
Regards
Neetha
Thanks Guys for helping me out.:)