dwhansen-cbg
6 years agoContributor
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...
- 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