Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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;
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;
In MONTH field what type of data you have for october month.
Got it. Its fixed. Thank you for all your feedback
Great, Please close this thread by flag "Correct Answer". Read more the usage Qlik Community Tip: Marking Replies as Correct or Helpful