Originally posted by: johnxp

Hi, Anyone can help for below the issue?

I am using NOT in Extract function, however, it's not working.

Rule 1: (it's working, it extracts records based on my conditions)

MyItem(s) = EXTRACT(MyItem, MyItem.ID1 = "A" & MyItem.ID2="B")

Rule 2: (it's not working, it extracts all items instead.)

MyItem(s) = EXTRACT(MyItem, NOT(MyItem.ID1 = "A" & MyItem.ID2="B"))

Originally posted by: Laurent(Satisco)

Hi,i cannot test at the moment, so I'll ask a question instead.Did you test by negating the conditions?

Checking what happens if you EXTRACT (myitem, myitem.id1 != 1 | myitem.id2 != 2) will show if the NOT does not work as expected or if something else is happening. sorry if you did the test already, but this seems at least worth the check.

Originally posted by: paul.brett

Works for me.  See example attached.

Input:

A:B:This is AB
A:C:This is AC
C:B:This is CB
C:D:This is CD
B:A:This is BA

Rule:

=F_EachItem(EXTRACT(Row:In1,NOT(ID1 IDItem:Row:In1="A" & ID2 IDItem:Row:In1="B")))

Output:

This is AC
This is CB
This is CD
This is BA

Let me know if I missed something.

Thank-you.

Paul.

Follow me on Twitter

Attachment(s)

Not.zip   2 KB 1 version