Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have an issue with proper filtering data table.
I have also asked chatGPT but he can't clear this.
I need filtered this table:
1 I need only December 2022 and later included
2 I need exclude any row with "COR" contained in field H_DOCUMENT_NUMBER
There is probably syntax error with stacking two where clauses but single try with only excluding "COR" don't work as demand too.
LOAD
'SALES' as TABLE,
H_DOCUMENT_NUMBER as DOCUMENT_NUMBER,
CUSTOMER_ID,
MATERIAL as "FG Code",
//"Short model name" as "Short model",
H_TO_NET_EUR as "TO NET",
DATE(MONTHSTART(DATE_UNLOADING), 'YYYY_MM') as CAL_YYYY_MM,
TO_REGION
FROM [lib://QVD tabele:DataFiles/SCEP_ALL_AN_SALES.QVD]
(qvd) WHERE DATE(MONTHSTART(DATE_UNLOADING), 'YYYY_MM') >= '2022_12'
OR NOT H_DOCUMENT_NUMBER LIKE '%COR%';
Assuming the field DATE_UNLOADING is an actual date field
Where MONTHSTART(DATE_UNLOADING) >= makedate(2022,12,1)
OR NOT H_DOCUMENT_NUMBER LIKE '%COR%';
I have tried both versions, but it seems as if this does not work as I need.
Concatenate (COMPARE)
LOAD
'SALES' as TABLE,
H_DOCUMENT_NUMBER as DOCUMENT_NUMBER,
CUSTOMER_ID,
MATERIAL as "FG Code",
//"Short model name" as "Short model",
H_TO_NET_EUR as "TO NET",
DATE(MONTHSTART(DATE_UNLOADING), 'YYYY_MM') as CAL_YYYY_MM,
TO_REGION
FROM [lib://QVD tabele:DataFiles/SCEP_ALL_AN_SALES.QVD]
(qvd)
WHERE DATE(MONTHSTART(DATE_UNLOADING), 'YYYY_MM') >= date#('2022_12', 'YYYY_MM')
OR NOT (Wildmatch (H_DOCUMENT_NUMBER, '*COR*')=0)
/*WHERE DATE(MONTHSTART(DATE_UNLOADING), 'YYYY_MM') >= date#('2022_12', 'YYYY_MM')
OR NOT (H_DOCUMENT_NUMBER LIKE '%COR%')*/;
After loading both are included. When I use below script for filtering data it filtered YYYY_MM in right way but this "COR" doesn't work with any modification. I attached app.
WHERE DATE(MONTHSTART(DATE_UNLOADING), 'YYYY_MM') >= '2022_12'