Forum Discussion

dwhansen-cbg's avatar
dwhansen-cbg
Contributor
6 years ago
Solved

Create new document per value in multi-value field

I have 40 columns in a pipeline that all store multiple values per row. They will all have the same number of values per row. They are delimited like: 7{C ;C ;C ;C ;MD;MD;MD}. My questions are: 1...
  • dwhansen-cbg's avatar
    6 years ago

    One way I figured out to do this is use UNNEST(STRING_TO_ARRAY()) in an execute SQL snap.

    UNNEST(STRING_TO_ARRAY(nested_multi_value_field)) as unnested_multi_value_field