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.

[sunny_talwar]

Is it possible that you are loading the same field ITEM_NO_IN_SUMMARY_TABLE at another place may be which is not restricted by the same Match() in where clause?

[sgrice]

Match returns 0 if no match

Change

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

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

[#4]

Yes. This Summary table is the only table which filters by these specific item numbers. But I have carefully checked only this single table with pivot table, chart and export of the table and the wrong item number shows up in this table.

[tresesco]

Or, sometimes it could be because of unwanted spaces in the data. Try like:

Where Match(Trim(ITEM_NO_IN_SUMMARY_TABLE),'BACTMW0150001', ....

[sunny_talwar]

Good one tresesco

[#7]

Steven I tried that, no change

[#8]

tresesco‌ Tried it. No change yet. The table remains untouched after the LOAD statement I can assure you. It also filters out other Item Numbers!!!! just this one (BYSMW00600001) remains in.

[sunilkumarqv]

I noticed you included in where condition

ITEM_NO_IN_SUMMARY_TABLE = BYSMW00600001

Try this

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

[#10]

sunilkumarqv‌ good idea. After doing the modification It filters out both wanted and unwanted item.

Wanted Item: BYSMW00060001

Unwanted Item: BYSMW00600001