Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
if(Currency = 'USD',
40,
ApplyMap('AmountMapping', Year([Date])& Month([Date])&[Currency],'1')
)
AS [Amount],