Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
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
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