Merge Q1, Q2 etc. to years

[chris_andersson]

Hello,

I have a table which contains data from quarters but not year total. 2016Q4, 2017Q1 and so on.

Can I merge the 2016Q1,q2,q3, q4 to a "2016" using the LOAD statement?

[sunny_talwar]

You should be able to... do you mind sharing your current script?

[avinashelite]

Yes , try like this

left(Quater_feild,4) as Year

[oknotsen]

"Yes we can".

It should look something like this:

Load

someKeyField,

sum(someData),

year

From source

group by year, someKeyField

;