Excluding Values on Load with WHERE AND..

[educastri83]

Hi, im trying to exclude some information my load statement, but one of the parts to be excluded is missing:

LOAD  

  ..........

FROM [$(vPath)\*.xlsx]

(ooxml, embedded labels, table is data)

WHERE NOT Match (CHARGE_CODE_KEY, '2286')

and ( CHARGE_TYPE_KEY <> '1001'  and CHARGE_NET_AMOUNT > 1);

The 1st part works fine, (i mean.. exclude any entry in the data where CHARGE_CODE_KEY = 2286)

but I also want to exclude cases when CHARGE_TYPE_KEY  '1001' but solve when CHARGE_NET_AMOUNT it is greater than 1

It's weird but there should not be discounts with a positive sign, that's why CHARGE_NET_AMOUNT are greater than one

Pd:

Charge_type_Key '1001' are operations of discount..

stalwar1‌

Thank You

[swuehl · Accepted solution]

I am not sure that I understand your requirements on the second part. What do you mean with 'but solve when ...'?

Can you maybe post some sample input records and your required output?

[educastri83]

Stefan!

Thank you, I saw that it was, I made some adjustments and now it is solved

WHERE NOT Match (CHARGE_CODE_KEY, '2286')

and ( CHARGE_TYPE_KEY <> '1001' or CHARGE_NET_AMOUNT < 1);