Create a table from 2 source tables

[#1]

Very new to QlikView.

I am getting an error saying "Field not found - <NHT_Full_Name>" in the Matched_Data function. How do I incorporate the NHT_Table column in the Matched_Data function? I tried to add the NHT_Table in the resident list and it is another error. [:(]

H_Table:

Directory;

LOAD H_Entry_Status,

H_Name,

H_Family&'-Family' as Prod_Family,

H_Product&'-Product' as Product,

H_CSP,

H_Region as H_RegionGMA,

upper(H_Country) as Country

FROM

NHT_Match.xls

(biff, embedded labels, table is [Sheet2$]);

NHT_Table:

Directory;

LOAD NHT_Hire_ID,

NHT_Prod_Family as Prod_Family,

NHT_Prod as Product,

NHT_First_Name,

NHT_Last_Name,

NHT_First_Name&' '&NHT_Last_Name as NHT_Full_Name,

FROM

NHT_Match.xls

(biff, embedded labels, table is [Sheet1$]);

Matched_Data:

load H_Name as Matched_Name,

Prod_Division, Prod_Group, Prod_Family, Product

resident H_Table

where exists (H_Name,NHT_Full_Name);

[d_pranskus · Accepted solution]

Hi

The APi for Exist function is as follows

exists( field [ , expr ] )

So try to swich arguments for Exists function, i.e. exists(NHT_Full_Name, H_Name)

Cheers

Darius