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