Re: Coalesce 2 Arrays

2019-06-24 Thread Rob Sargent
On 6/24/19 5:19 PM, David G. Johnston wrote: On Mon, Jun 24, 2019 at 4:11 PM Rob Sargent > wrote: On 6/24/19 4:46 PM, Alex Magnum wrote: Yes, they are. On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent mailto:robjsarg...@gmail.com>> wrote:

Re: Coalesce 2 Arrays

2019-06-24 Thread David G. Johnston
On Mon, Jun 24, 2019 at 4:11 PM Rob Sargent wrote: > > On 6/24/19 4:46 PM, Alex Magnum wrote: > > Yes, they are. > > On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent wrote: > >> >> >> On Jun 24, 2019, at 2:31 PM, Alex Magnum wrote: >> >> Hi, >> I have two arrays which I need to combine based on the

Re: Coalesce 2 Arrays

2019-06-24 Thread Rob Sargent
On 6/24/19 4:46 PM, Alex Magnum wrote: Yes, they are. On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent > wrote: On Jun 24, 2019, at 2:31 PM, Alex Magnum mailto:magnum11...@gmail.com>> wrote: Hi, I have two arrays which I need to combine based on the in

Re: Coalesce 2 Arrays

2019-06-24 Thread Rob Sargent
On 6/24/19 4:46 PM, Alex Magnum wrote: Yes, they are. On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent > wrote: On Jun 24, 2019, at 2:31 PM, Alex Magnum mailto:magnum11...@gmail.com>> wrote: Hi, I have two arrays which I need to combine based on the in

Re: Coalesce 2 Arrays

2019-06-24 Thread Alex Magnum
Yes, they are. On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent wrote: > > > On Jun 24, 2019, at 2:31 PM, Alex Magnum wrote: > > Hi, > I have two arrays which I need to combine based on the individual values; > i could do a coalesce for each field but was wondering if there is an > easier way > > ar

Re: Coalesce 2 Arrays

2019-06-24 Thread Rob Sargent
> On Jun 24, 2019, at 2:31 PM, Alex Magnum wrote: > > Hi, > I have two arrays which I need to combine based on the individual values; > i could do a coalesce for each field but was wondering if there is an easier > way > > array_a{a, null,c, d,null,f,null} primary > array_b{null,2 ,nul

Coalesce 2 Arrays

2019-06-24 Thread Alex Magnum
Hi, I have two arrays which I need to combine based on the individual values; i could do a coalesce for each field but was wondering if there is an easier way array_a{a, null,c, d,null,f,null} primary array_b{null,2 ,null,4,5 ,6,null} secondary result {a, 2, c, d,5, f,null) Any