2 Replies Latest reply: Sep 11, 2012 7:40 AM by Pedro Burgo RSS

    Error using 2 ApplyMap consecutively

      Hi, while I'm loading a table I use ApplyMap to add a new field this way:

       

        ApplyMap('MapGestSuppliers',LotNumber,Null()) AS SupplierID,
      
      

       

      So I get the field SupplierID, but If I add a second ApplyMap, this way

       

       ApplyMap('MapGestSuppliers',LotNumber,Null()) AS SupplierID,
      ApplyMap('Map_CustVendorName',SupplierID,Null()) AS SupplierName
      

       

      trying to use the first result (SupplierID) in the second mapping It gives an error while loading the table

       

      Field <SupplierID> Not found.

       

      If I can't do this this way, how can I add later another field to the table previously loaded.

       

      Thanks