Match() weird issue

[#1]

Hi all

I've this very straight forward expression:

OVERAL_SUMMARY_TAB_TEMP:

LOAD

ITEM_NO_IN_SUMMARY_TABLE AS ITEM_NO_IN_SUMMARY_TAB,

CUST_NO_IN_SUMMARY_TABLE AS CUST_NO_IN_SUMMARY_TAB,

CUST_TYPE_IN_SUMMARY AS CUST_TYPE_IN_SUMMARY_TAB,

SUM_BY_ITEM_NUMBER AS SUM_BY_ITEM_NUMBER_FOR_SUMMARY_TAB,

MOQ AS MOQ_FOR_SUMMARY_TAB

Resident SUMMARY_OVERAL

WHERE Match(ITEM_NO_IN_SUMMARY_TABLE,'BACTMW0150001','BYSMW00150001','BACTMW0050001','BYSMW00060001');

but in my table I still have items with ITEM_NO_IN_SUMMARY_TABLE = BYSMW00600001

Download the qvw with datasources from here: Dropbox - Beverage Penetration and 4K_20150622.zip

Please pay attention that the included item number is not in match statement. Please help.

[#2]

the problem is when I include BYSMW00060001, the unwanted item is also included in the table. please note there are two different items (number of zeros before and after 6)

Wanted Item: BYSMW00060001

Unwanted Item: BYSMW00600001

[swuehl · Accepted solution]

Still missing your issue.

I am looking at "4K Tracking and Beverage - LAST MONTH - Copy.qvw"

You are using

OVERAL_SUMMARY_TAB_TEMP:

LOAD

ITEM_NO_IN_SUMMARY_TABLE AS ITEM_NO_IN_SUMMARY_TAB,

CUST_NO_IN_SUMMARY_TABLE AS CUST_NO_IN_SUMMARY_TAB,

CUST_TYPE_IN_SUMMARY AS CUST_TYPE_IN_SUMMARY_TAB,

SUM_BY_ITEM_NUMBER AS SUM_BY_ITEM_NUMBER_FOR_SUMMARY_TAB,

MOQ AS MOQ_FOR_SUMMARY_TAB

Resident SUMMARY_OVERAL

WHERE Match(Trim(ITEM_NO_IN_SUMMARY_TABLE),'BACTMW0150001','BYSMW00150001','BACTMW0050001', 'BYSMW00060001');

Thus renaming ITEM_NO_IN_SUMMARY_TABLE to ITEM_NO_IN_SUMMARY_TAB.

If I look at the field values of ITEM_NO_IN_SUMMARY_TAB:

BACTMW0050001

BACTMW0150001

BYSMW00060001

BYSMW00150001

I don't see the unwanted item. Do you?

The original table SUMMARY_OVERAL and field ITEM_NO_IN_SUMMARY_TABLE shows:

BACTMW0050001

BACTMW0150001

BYSMW00060001

BYSMW00150001

BYSMW00600001

But that's not the table you've filtered!

I don't see your issue please point me to the occurence of your filtered field showing a value not contained in the match() of the WHERE clause.