Incremental Load with year and Month

[abhaysingh]

Hey guys,

I have a table in which year and month is available.. i need the script to pull the data of single month only rather than whole table which is time taking..

Can any one help me in this?

[marcus_sommer]

You could with makedate(Year, Month) create a single field which you could use within an incremental approach. Here you will find (beside some other useful informations) various examples to this topic: Advanced topics for creating a qlik datamodel.

- Marcus

[Anonymous]

may be something like this?

Let Vmonth=month(Today());

Let Vyear=year(Today());

Load *

From Yourtable

where MonthField=$(Vmonth) and YearField=$(Vyear);

[#4]

Incremental load for beginner with example

https://community.qlik.com/docs/DOC-17353

check the above link