1 Reply Latest reply: Apr 15, 2010 11:41 AM by Darius Pranskus RSS

    Create a table from 2 source tables

    kathyw

      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);