5 Replies Latest reply: Oct 30, 2013 5:39 AM by Erik Furlanis RSS

    tiny question about ApplyMap syntax

      I was reading the great explanation regarding ApplyMap by Steve Dark

       

      http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

       

      a question came up in my mind:

       

      if I have

      MapProducts:
      MAPPING LOAD
      ProductID,
      description;
      
      LOAD
      Order
      ApplyMap('MapProducts',ProductID,'N/A') as Item
      RESIDENT Order_table;
      

       

      is this expected to work perfectly, since I am not explicitly loading ProductID from the resident Order_table?

      Further, by using this syntax, I should NOT expect to see the field ProductID in the dashboard, right?

       

      thank you!