1 Reply Latest reply: Mar 18, 2017 11:01 AM by Massimo Grossi RSS

    map

    raadwiptec g

      Iam trying to apply the following applymap condition

       

      AmountMapping

      Mapping Load

      Year([Date])& Month([Date])&[Currency]

      amount

      from Amount.txt

       

       

      ApplyMap('AmountMapping', Year([Date])& Month([Date])&[Currency],'1') AS [Amount],

       

      But i need the condition like this.

      If Currency - 'USD' then it should be '40'  always irspective of years else it should take the currency amount from the Amount.txt file-

      The second condition is the year should be 2017..