Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Incremental Load - Show only Months No Quarters

Hi All,

Dealing with strange  scenarios in Incremental Load for our Project.

We have following kind of Data.

        

ProcessID    ProcessDate      Metrics          Dimensions

1                        2016-01-01

2                        2016-02-01

3                        2016-03-01

4                        2016-04-01

5                        2016-05-01

6                        2016-06-01

7                        2016-0701

and so on till December and continued till 2017 Feb

Here, 3,6,9 and 12 means  Quarter as in Q1,Q2,Q3,Q4.

1. Scenario 1 ---- I need to show only Months data i.e. 1,2,4,5,7,8,10,11

2. Scenario 2 --- need to show only last Quarter means Q4 of any available Year in QVD it could be  2015, 2016 (history QVD already created) and 2017 data is in database.

Kindly help.

Looking forward for valuable inputs.

0 Replies