4 Replies Latest reply: Oct 30, 2012 7:09 AM by Peter Brunner RSS

    Populating data in a blank field Null Mapping ?

    Peter Brunner

      Hi Guys,

       

      I have been testing different ways to solve this problem with eratic results

      I need to map the blank PG field with PX. I tried a wildcard *REV* and no go

      I now have a test model setup with mapping but there might be a better way of doing this

      see my Test Qvw attched.

       

       

      data:

      load * inline [
      ITEM, PG, Value
      123123,AS, 2300,
      620023,BC, 5000,
      1-REV-I,  ,9000,
      2-REV-I,  ,9001
      3-REV-I,  ,9002
      4-REV-I,  ,8200,
      5-REV-I,  ,7000,
      6-REV-I,  ,760,
      7-REV-I,  ,8800,
      8-REV-I,  ,800,
      9-REV-I,  ,3210,
      ]
      ;

      MAP_NewCode:
      mapping load * inline [
      ITEM, PG,
      1-REV-I,PX
      2-REV-I,PX
      3-REV-I,PX
      4-REV-I,PX
      5-REV-I,PX
      6-REV-I,PX
      7-REV-I,PX
      8-REV-I,PX
      9-REV-I,PX
      ]
      ;

      data2:
      load
      ITEM,
      if (PG=' ', ApplyMap('MAP_NewCode', ITEM, PG)) as PGs,
      Value
      Resident data;
      drop Table data;

       

       

       

       

       

       

       

       

       

       

       

      any help would be appreciated

      Peter