Including records that have a certain criteria

[#1]

Hi

I have a field called Cost Element that will return and I only want to include records that start with 000051 and 0000843

The field returns various cost elements and the full length is 0000510088

I want to try and do this in the laod script

[alexandros17]

Load

...

From

...

Where Left([Cost Element], 6)='000051' or Left([Cost Element], 7)='0000843'

Let me know

[#3]

Hi Andrew,

Wildmatch([Cost Element], '000051*','0000843*)

should do the trick, use that in your load where clause to reduce down your loaded rows

hope that helps

Joe