Rating File Question

Follow

Paul Taylor

23 June 2011 09:12

Hi guys.

I've got a lookup file, with postcodes that map to a single character, A-E. 

Within the rate-file, I apply a different loading depending on the A-E result.

However, this file only contains those postcodes that we want to load (a fairly small subset of all possible postcodes). For all other postcodes, we want to apply a discount.

So how do I specify that if the postcode ISN'T in my postcode file, I apply a discount?

Cheers

Paul

 

0

• 

  Paul Taylor 26 June 2011 10:32

  Hi Guys,

  Have you had chance to look at this question?

  Thanks

  Paul

  0

  Comment actions Permalink
• 

  Rob Symonds 27 June 2011 11:16

  Hi Paul,

  The solution to this can apply to any situation where you need to test that a given question is not in a given lookup table.

  ###

  AnswerLookup:QuestionToCheck|Lookup table to check

  null

  ### 

  Thanks,

  Rob.

  0

  Comment actions Permalink
• 

  Paul Taylor 27 June 2011 11:24

  Hi Rob,

  Thanks! Do I actually enter "null" or blank?

  Cheers

  Paul

  0

  Comment actions Permalink
• 

  Rob Symonds 27 June 2011 11:29

  Hi Paul,

  No problem - You need to use "null" - a blank string will not work.

  Thanks for checking :o)

  0

  Comment actions Permalink

Please sign in to leave a comment.