Where clause within Load Script

[kailashkotak91]

Hello,

Following is my load script. I want to use where statement to filter year as 2017 and month as October. How can i do that ?

OLEDB CONNECT TO [My Connection String];

LOAD

    CHARGE as Charge_Table1,

    INVCCAT as InvCAT_Table1 ,

    MONTH as Month_Table1,

    YEAR as  Year_Table1,

SQL SELECT *

FROM Table 1;

Thank you in advance.

Regards.

[Anil_Babu_Samineni]

Try this?

OLEDB CONNECT TO [My Connection String];

LOAD

    CHARGE as Charge_Table1,

    INVCCAT as InvCAT_Table1 ,

    MONTH as Month_Table1,

    YEAR as  Year_Table1 Where MONTH = 'October' and YEAR = 2017;  

SQL SELECT *

FROM Table 1;

[its_anandrjs]

Try this

OLEDB CONNECT TO [My Connection String];

LOAD

    CHARGE as Charge_Table1,

    INVCCAT as InvCAT_Table1 ,

    MONTH as Month_Table1,

    YEAR as  Year_Table1

Where YEAR =  Yeaar(Today()) and MONTH  = 'Oct' ;

SQL SELECT *

FROM Table 1;

[its_anandrjs]

In MONTH field what type of data you have for october month.

[kailashkotak91]

Got it. Its fixed. Thank you for all your feedback

[Anil_Babu_Samineni]

Great, Please close this thread by flag "Correct Answer". Read more the usage Qlik Community Tip: Marking Replies as Correct or Helpful