Answers/SchemeServe Answers

Answered

Rating File Question

Paul Taylor
asked this on June 23, 2011 10: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

 
 

Comments

User photo
Paul Taylor

Hi Guys,

Have you had chance to look at this question?

Thanks

Paul

June 26, 2011 11:32
User photo
Rob Symonds
ADM Network Ltd
Ajax_loader_small Answer

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.

June 27, 2011 12:16
User photo
Paul Taylor

Hi Rob,

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

Cheers

Paul

June 27, 2011 12:24
User photo
Rob Symonds
ADM Network Ltd

Hi Paul,

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

Thanks for checking :o)

June 27, 2011 12:29
Add a comment