I know how to pivot, but how to aggregate and pivot and build those True and False combination is the doubt.
On Fri 8 May, 2020, 1:31 PM Edgardo Szrajber, <szraj...@yahoo.com> wrote: > Have you checked the pivot function? > Bentzi > > Sent from Yahoo Mail on Android > <https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature> > > On Thu, May 7, 2020 at 22:46, Aakash Basu > <aakash.spark....@gmail.com> wrote: > Hi, > > I've updated the SO question with masked data, added year column and other > requirement. Please take a look. > > Hope this helps in solving the problem. > > Thanks and regards, > AB > > On Thu 7 May, 2020, 10:59 AM Sonal Goyal, <sonalgoy...@gmail.com> wrote: > > As mentioned in the comments on SO, can you provide a (masked) sample of > the data? It will be easier to see what you are trying to do if you add the > year column > > Thanks, > Sonal > Nube Technologies <http://www.nubetech.co> > > <http://in.linkedin.com/in/sonalgoyal> > > > > > On Thu, May 7, 2020 at 10:26 AM Aakash Basu <aakash.spark....@gmail.com> > wrote: > > Hi, > > I've described the problem in Stack Overflow with a lot of detailing, can > you kindly check and help if possible? > > https://stackoverflow.com/q/61643910/5536733 > > I'd be absolutely fine if someone solves it using Spark SQL APIs rather > than plain spark SQL query. > > Thanks, > Aakash. > >