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