Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For ex: I do a apply map from the invoice rate table
Mapping Load,
Year & Month
Invoice Rate
xxxxx
so based on my year and month for ex if it 2017 01 then invoice rate would be used and multipllied with the end column
for 2016 12 the specific rate would be multiplied.
Now i want to apply 2017 rates all the previous years.
any sugg
hi
So 201701 invoice rate need to apply for 201601, similarly for 201702 invoice rate need to apply for 201602. in that case, try like below
MapInvoiceRate:
Mapping load Month, InvoiceRate from sourcetable where Year = 2017;
In applymap state,
Applymap('MapInvoiceRate', Month)
could you please explain with an example that would be better to understand