Yes, they are.
On Tue, Jun 25, 2019 at 4:33 AM Rob Sargent <robjsargent(at)gmail(dot)com> wrote:
>
>
> On Jun 24, 2019, at 2:31 PM, Alex Magnum <magnum11200(at)gmail(dot)com> 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 ,null,4,5 ,6,null} secondary
>
> result {a, 2, c, d,5, f,null)
>
> Any advice would be appreciated
>
> Are the inputs always of fixed dimensions eg. 1 by 7?
>
>