To pick data after a specific date!

[nevilledhamsiri]

Hi, Dear

Sample data shown here are  some transaction taken place in July.(CR_DATE), If I am to chose data of which from date falls after 10th March, how this will be done in the script,Thereby If I can create  after & before cut off date (10th March) I may be able to separate data from that cut of date. script too attached for your reference!

REFUNDS:

LOAD

    BRANCH,

    CLASS_CODE,

    PRODUCT_CODE,

    POLICY_NO,

    NAME_OF_INSURED,

    CREDIT_NOTE_NO,

    CREDIT_NOTE_DATE,

    DATE(CREDIT_NOTE_DATE)AS CR_DATE,

    PERIOD_FROM,

    DATE( PERIOD_FROM) AS FROM_DATE,

    PERIOD_TO,

    PREMIUM,

    ADDRES,

     REASON,

      FINANCIAL_INTEREST,

     ME_CODE, ME_NAME

FROM (biff, embedded labels, table is Sheet1$);

Thanks

Neville

[vkish16161 · Accepted solution]

Neville,

Something like this:

REFUNDS:

LOAD

    BRANCH,

    CLASS_CODE,

    PRODUCT_CODE,

    POLICY_NO,

    NAME_OF_INSURED,

    CREDIT_NOTE_NO,

    CREDIT_NOTE_DATE,

    DATE(CREDIT_NOTE_DATE)AS CR_DATE,

    PERIOD_FROM,

    DATE( PERIOD_FROM) AS FROM_DATE,

    PERIOD_TO,

    PREMIUM,

    ADDRES,

     REASON,

      FINANCIAL_INTEREST,

     ME_CODE, ME_NAME

FROM (biff, embedded labels, table is Sheet1$)

where  CR_DATE > 03/01/2017;

[Anil_Babu_Samineni]

Do you mean this?

REFUNDS:

LOAD

    BRANCH,

    CLASS_CODE,

    PRODUCT_CODE,

    POLICY_NO,

    NAME_OF_INSURED,

    CREDIT_NOTE_NO,

    CREDIT_NOTE_DATE,

    DATE(CREDIT_NOTE_DATE) AS CR_DATE,

    PERIOD_FROM,

    DATE( PERIOD_FROM) AS FROM_DATE,

    PERIOD_TO,

    PREMIUM,

    ADDRES,

    REASON,

      FINANCIAL_INTEREST,

    ME_CODE, ME_NAME

FROM (biff, embedded labels, table is Sheet1$) FROM DATE(CREDIT_NOTE_DATE) = '3/10/2017';

[nevilledhamsiri]

Dear Vishnu,Anil,

Thanks a lot your suggestions  work! Suppose I join a separate file which carries credit_note_number which field is already there in the file already loaded. If I am to say Credit_note_number in the first file equals to Credit_note_number in the 2nd file to be dropped (excluded) & only to appear others  how it could be done! Then my conditions are

1_ Seect only cases where period_from date >07/0/2017 which is already achieved as you suggested.

2_ excludes cases where credit_note_numbers are the same

Thanks

Neville.

REFUNDS:

LOAD

    BRANCH,

    CLASS_CODE,

    PRODUCT_CODE,

    POLICY_NO,

    NAME_OF_INSURED,

    CREDIT_NOTE_NO,

    CREDIT_NOTE_DATE,

    PERIOD_FROM,

    PERIOD_TO,

    PREMIUM,

    ADDRES,

     REASON,

      FINANCIAL_INTEREST,

     ME_CODE, ME_NAME

FROM (biff, embedded labels, table is Sheet1$)

WHERE PERIOD_FROM >'7/10/2017';

POL:

LOAD CREDIT_NOTE_NO

FROM (ooxml, embedded labels, table is Sheet2);

[nevilledhamsiri]

Dear qlikers!

Thanks for your help!

Eventually I was able to achieve my output! Forward the same for your reference!