Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
PFA
1: i want last 3 months of data in 3 Qvds based on the field case "CaseClose" .
2: If "Case_Key" is not closed ,i need to put 'CaseClose' as "NotClosed"
How to achieve this
pls help
thanks in advance.
Thanks& Regards,
Koti
May be this?
Raw:
LOAD CaseOpen,
Case_Key,
CaseClose,
If(Len(Trim(CaseClose)) = 0, MonthName(Today()), MonthName(CaseClose)) as CaseClose_Temp
FROM
Raw.xlsx
(ooxml, embedded labels, table is Sheet1);
FOR i = 0 to -2 step -1
Temp:
NoConcatenate
LOAD CaseOpen,
Case_Key,
CaseClose
Resident Raw
Where Num(CaseClose_Temp) = Num(MonthName(AddMonths(Today(), $(i))));
LET vStore = Date(AddMonths(Today(), $(i)), 'MMMYYYY');
STORE Temp into $(vStore).qvd (qvd);
DROP Table Temp;
NEXT
Then where would the data go if the CaseClose is not closed?
if caseclose is not there please add that to current date
May be this?
Raw:
LOAD CaseOpen,
Case_Key,
CaseClose,
If(Len(Trim(CaseClose)) = 0, MonthName(Today()), MonthName(CaseClose)) as CaseClose_Temp
FROM
Raw.xlsx
(ooxml, embedded labels, table is Sheet1);
FOR i = 0 to -2 step -1
Temp:
NoConcatenate
LOAD CaseOpen,
Case_Key,
CaseClose
Resident Raw
Where Num(CaseClose_Temp) = Num(MonthName(AddMonths(Today(), $(i))));
LET vStore = Date(AddMonths(Today(), $(i)), 'MMMYYYY');
STORE Temp into $(vStore).qvd (qvd);
DROP Table Temp;
NEXT
Hi sunny i opened new thread Issue In Splitting QVD's please look on it.