Script Help

[hopkinsc]

.

Hi, i am trying to do something in my script but i'm not sure how to do it..

I am loading in a table with the following fields..

PosTransactionDetail:

LOAD

     StoreNumber,

     TransId,

     EANCode AS EAN,

     VATIndicator,

     VATAmountDue,

     VATBase,

     LineType,

     SaleStartDate

FROM xyz

But i don't want to load in any POSITIVE VATbase values with the LineType of V (But still want to include the NEGATIVE LineTypes of V)

Can anyone help me to achieve this please?

[john_duffy · Accepted solution]

Hello.

Try adding a Where clause such as 'not(LineType = 'V' and VATBase > 0)'.

John.

[hopkinsc]

Hi John,

This is what i did..

PosTransactionDetail:

LOAD

     StoreNumber,

     TransId,

     EANCode AS EAN,

     VATIndicator,

     VATAmountDue,

     VATBase,

     LineType,

     SaleStartDate

FROM $(cFileName) (qvd) Where not(LineType = 'V' and VATBase > 0);

But this excluded ALL lineTypes of V except ZERO....

Any ideas?

[hopkinsc]

John, sorry, ignorfe me, i had a selection wrong. That did what i wanted, but have found another problem. Just trying to find out what the problem is,...