Script Problem

[d_koti24]

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

[sunny_talwar]

Then where would the data go if the CaseClose is not closed?

[d_koti24]

if caseclose is not there please add that to current date

[sunny_talwar · Accepted solution]

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

[d_koti24]

Hi sunny i opened new thread Issue In Splitting QVD's please look on it.