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.

[sgrice]

I think that the issue might be that you are using a resident table. and your new results are just appending to the old ones

OVERAL_SUMMARY_TAB_TEMP:

NoConcatenate

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

DROP TABLE SUMMARY_OVERAL;

[#3]

I want the item number: BYSMW00060001 not BYSMW00600001 included in the table. Therefore I tried:

OVERAL_SUMMARY_TAB_TEMP:

NoConcatenate

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

Still no change.

PLEASE NOTE I AM USING summary_overal in other charts and sheets and cannot drop it.

[#4]

Btw I am uploading the qvw and datasource so you can try to diagnosis with better accuracy and reload the result.

[#5]

Btw I am uploading the qvw and datasource so you can try to diagnosis with better accuracy and reload the result.

[sunny_talwar]

and did you drop SUMMARY_OVERALL?

DROP Table SUMMARY_OVERALL;

[#7]

Btw I am uploading the qvw and datasource so you can try to diagnosis with better accuracy and reload the result.

[#8]

Btw I am uploading the qvw and datasource so you can try to diagnosis with better accuracy and reload the result.

[#9]

no that table is needed somewhere else. If it is necessary to drop it, my other tables' data become problematic. This table is SUMMARY_OVERALL just for these 4 Items.
If you think this is the issue, how can I maintain my other tables data?

[#10]

I dropped the SUMMARY_OVERALL for testing. still no change pal

[swuehl]

Sorry, in which chart do you see that field ITEM_NO_IN_SUMMARY_TABLE = BYSMW00600001 still exists?

I am looking at your LAST MONTH COPY application, and there are four possible values for that field:

BACTMW0050001

BACTMW0150001

BYSMW00060001

BYSMW00150001

Seems pretty much what you filter in your WHERE clause

...'BACTMW0150001','BYSMW00150001','BACTMW0050001','BYSMW00060001')

So, could you point me to the exact occurence of the mysterious value?