...
When the Subscriptions column contains cleanly formatted arrays, the column is re-typed as Array type. You can then apply the flatten transform:
| D code |
|---|
flatten col:Subscriptions |
Each CustId/Subscription combination is now written to a separate row. You can use this new data structure to break out instances of magazine subscriptions. Using the following transform, you can add the corresponding CustId value to the column:
| D code |
|---|
valuestocols col:Subscriptions value:CustId |
Drop the two source columns:
| D code |
|---|
drop col:CustId,Subscriptions |
Results:
| Little_House_and_Garden | Sporty_Pants | Life_on_the_Range | Investing_for_Tomorrow | Cakes_and_Pies | Powerlifting_Plus | Running_for_Days |
|---|---|---|---|---|---|---|
| Anne Aimes | ||||||
| Anne Aimes | ||||||
| Anne Aimes | ||||||
| Barry Barnes | ||||||
| Barry Barnes | ||||||
| Cindy Compton | ||||||
| Cindy Compton | ||||||
| Cindy Compton | ||||||
| Darryl Diaz | ||||||
| Darry Diaz |
