Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.