map

raadwiptec — Sat, 18 Mar 2017 13:43:10 GMT

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

Re: map

maxgro — Sat, 18 Mar 2017 15:01:33 GMT

if(Currency = 'USD',

40,

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

)

AS [Amount],