Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
educastri83
Creator
Creator

Excluding Values on Load with WHERE AND..

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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?

View solution in original post

2 Replies
swuehl
MVP
MVP

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
Creator
Creator
Author

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);