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: 
Not applicable

Monthly distribution of value

Hi Team,

Please help me out by suggesting a solution below is the scenario for my problem

I have a value that is to be divided by remaining month in a year and equaly distributed among remaining months.


The value of month comes from other file. So say for example the attached excel file contain data for the month of Jan 2017. Now, i have to divide values by 11 (12-1) and distribute that value among remaining months. (Feb to Dec 2017)

Thanks in advance

  Input:  

DeptIndiaChinaUSEurope
126
38030 14
5 548131
724 6647
9 938681
1192 12
13 8429

71


Output:

   

DeptRegionMonthData
1IndiaJan0
1IndiaFeb2.4
1IndiaMar2.4
1IndiaApr2.4
1IndiaMay2.4
1IndiaJun2.4
1IndiaJul2.4
1IndiaAug2.4
1IndiaSep2.4
1IndiaOct2.4
1IndiaNov2.4
1IndiaDec2.4
1ChinaJan0
1ChinaFeb0
1ChinaMar0
1ChinaApr0
1ChinaMay0
1ChinaJun0
1ChinaJul0
1ChinaAug0
1ChinaSep0
1ChinaOct0
1ChinaNov0
1ChinaDec0
1USJan21
1USFeb0
1USMar0
1USApr0
1USMay0
2 Replies
sunny_talwar

I am not sure how you are getting 21 for US in Jan?

Capture.PNG

Not applicable
Author

Hi Sunny,

That value I am getting from a different table.  Below is the format for it.

Since, it contain data for jan month, we have to replace jan value to that table and take a difference of remaining months

   

DeptMonthYearIndiaChinaUSEurope
1jan2017 2128
3jan201717172825
5jan20171381414
7jan20171552212
9jan201725
11jan201737309
13jan201717192421
12jan2017 218