Re: Union of multiple datasets

2022-10-24 Thread abhijit
Thanks Jeremy. That works! On Friday, October 21, 2022 at 10:31:53 PM UTC+5:30 Jeremy Evans wrote: > On Fri, Oct 21, 2022 at 9:50 AM abhijit wrote: > >> Hi, >> >> I have multiple dataset queries. What would be the best way to create a >> union in this scenario? >> >> I have tried - >> >>

Re: Union of multiple datasets

2022-10-21 Thread Jeremy Evans
On Fri, Oct 21, 2022 at 9:50 AM abhijit wrote: > Hi, > > I have multiple dataset queries. What would be the best way to create a > union in this scenario? > > I have tried - > > ds1.union(ds2.union(ds3.union))) > > as well as > > ds1.union(ds2).union(ds3) > > In either case, the resulting SQL

Union of multiple datasets

2022-10-21 Thread abhijit
Hi, I have multiple dataset queries. What would be the best way to create a union in this scenario? I have tried - ds1.union(ds2.union(ds3.union))) as well as ds1.union(ds2).union(ds3) In either case, the resulting SQL looks unnecessarily nested, although the results are identical. Is