topic Re: Where clause within Load Script in QlikView

Where clause within Load Script

kailashkotak91 — Mon, 13 Nov 2017 16:08:26 GMT

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 — Mon, 13 Nov 2017 16:11:14 GMT

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 — Mon, 13 Nov 2017 16:12:45 GMT

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 — Mon, 13 Nov 2017 16:13:52 GMT

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

kailashkotak91 — Wed, 15 Nov 2017 00:17:06 GMT

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

Anil_Babu_Samineni — Wed, 15 Nov 2017 01:27:14 GMT

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