Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Iam trying to apply map as below. i get good results.
If(ApplyMap('Invoice Mapping',[invoices ])='158964'
,'Future'
,If(ApplyMap('Purchased Mapping',[Invoices]) ='158965'
,'Past'
)
)) as [Group],
My issue i want to add another invoice number for purchase mapping.. for ex as below
If(ApplyMap('Invoice Mapping',[invoices ])='158964'
,'Future'
,If(ApplyMap('Purchased Mapping',[Invoices]) ='158965','125698'
,'Past'
)
)) as [Group],
but this does work as it shows script error.. how to provide 2 invoice numbers in this situations..
Hi,
Try
.
.
,If(Match(ApplyMap('Purchased Mapping',[Invoices]),'158965','125698')
,'Past'
.
.
Cheers
Andrew
Its strange that you are using ApplyMap with if. Why don't you just map it correctly to past or future? Can you share a sample to see what exactly are you trying to do here?