0 Replies Latest reply: Sep 19, 2013 1:33 AM by Paul Yeo RSS

    How to add currency sign dynamic using load script ?

      Hi All

       

       

      when user select :-

       

       

      BRAND_P=BECKHOFF , PRICELIST to display EURO123

      BRAND_P=GE                , PRICELIST to display USD123

      BRAND_P=HAKKO        , PRICELIST to display USD123

      BRAND_P=MITSUBISHI , PRICELIST to display SGD123

       

       

      Right now my Script is below :-

       

       

      left join    (PRICE)

         

      Load PART_NO_,

       

       

          'USD '& LIST_PRICE as PRICELIST

       

       

      Resident PRICE;

       

       

      it make all PRICLIST filed fill with USD.

       

       

      I like Pick and match , so i try it but cannot work , may be i need to add more code :-

       

       

      Pick(Match(BRAND_P,'BECKHOFF','GE','HAKKO','MITSUBISHI'),'EURO','USA','USA,'SGD')& LIST_PRICE as PRICELIST