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


    raadwiptec g

      Iam trying to apply the following applymap condition



      Mapping Load

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


      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..