That’s a good idea. I’ll work on a equivalent ZIP() function and submit as a
separate PR.
— C
> On Apr 10, 2019, at 20:44, Paul Rogers <par0...@yahoo.com.INVALID> wrote:
>
> Hi Charles,
>
> In Python [1], the "zip" function does this task:
>
>
> zip([1, 2, 3], [4, 5, 6]) --> [(1, 4), (2, 5), (3, 6)]
>
>
> When you gathered the list of functions for the Drill book, did you come
> across anything like this in Drill? I presume you didn't, hence the question.
> I did a quick (incomplete) check and didn't see any likely candidates.
>
> Perhaps you could create such a function.
>
> Once you have the zipped result, you could flatten to get the pairs as rows.
>
>
> Thanks,
> - Paul
>
>
>
> On Wednesday, April 10, 2019, 5:26:10 PM PDT, Charles Givre
> <cgi...@gmail.com> wrote:
>
> Hello Drillers,
> I have a query question for you. I have some really ugly data that has a
> field like this:
>
> compound_field : { “field_1”: [1,2,3],
> “field_2”:[4,5,6]
> )
>
> I would like to map fields 1 and 2 to columns so that the end result is:
>
> field1 | field2
> 1 | 4
> 2 | 5
> 3 | 5
>
> I thought flatten() would be the answer, however, if I flatten the columns, I
> get the following result:
>
> field1 | field2
> 1 | 4
> 1 | 5
> 1 | 6
>
> Does anyone have any suggestions?
> Thanks,
> —C
