topic load with filter from another table in QlikView

load with filter from another table

Mon, 23 May 2016 18:13:14 GMT

Hi All!

I really appreciate your help with the following issue:_

I have 3 tables:

"Country_ID" (table name):

load

Phy_id,

Country

select * from Countries;

Activity:

load

Activites_phy_id,

Date,

Name;

select * from Activites;

Station:

load,

Station_phy_id,

Date,

Location;

select * from stations;

I need to load from Activity table and Station table only the phy_id that appears on country_id.phy_id.

I tried to do that with "where Exists(Phy_id, Activites_phy_id)" for example in the "Activity" table load but it didn't work. Can someone please advise?

Thanks!

Re: load with filter from another table

sunny_talwar — Mon, 23 May 2016 18:37:34 GMT

May be use the Where Exists statement here:

"Country_ID" (table name):

load

Phy_id,

Country;

select * from Countries;

Activity:

load

Activites_phy_id,

Date,

Name

Where Exists(Phy_id, Activites_phy_id);

select * from Activites;

Station:

load,

Station_phy_id,

Date,

Location

Where Exists(Phy_id, Station_phy_id);

select * from stations;

Re: load with filter from another table

Mon, 23 May 2016 19:16:34 GMT

Thanks for you response! but it didn't work I received the following error

"Script line Error

Else"

Re: load with filter from another table

sunny_talwar — Mon, 23 May 2016 19:20:26 GMT

Would you be able to share the logfile?