mapping

[raadwiptec]

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

[effinty2112]

Hi,

Try

.

.

,If(Match(ApplyMap('Purchased Mapping',[Invoices]),'158965','125698')

,'Past'

.

.

Cheers

Andrew

[sunny_talwar]

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?