I am trying to create a new fields from a multi value fields. Here's an example:
group_id, user_id user_address user_phone_number
a 123 cityA, NY, USA 123-234-345
234 cityBC, NJ, USA 234-345-345
b 567 cityDEF, NY, USA 234-345-456
stats list(user_id), list(user_address), list(user_phone_number) by group_id
user_id, user_address and user_phone_number are multi value fields.
I want to be able to extract state information from user_address to generate a table like this
group_id, user_id state user_phone_number
a 123 NY 123-234-345
234 NJ 234-345-345
b 567 NY 234-345-456
How can I achieve this?
... View more