Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

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_GardenSporty_PantsLife_on_the_RangeInvesting_for_TomorrowCakes_and_PiesPowerlifting_PlusRunning_for_Days
Anne Aimes      
 Anne Aimes     
  Anne Aimes    
 Barry Barnes     
   Barry Barnes   
    Cindy Compton  
     Cindy Compton 
      Cindy Compton
   Darryl Diaz   
    Darry Diaz