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
