And now presenting Part 5: Manipulating Data Structures with CSV aggregator and array functions
In this video we introduce the CSV aggregator to create comma separated text files. This aggregator can be very useful when you want to create columnar data from one or more bundles. In this case we convert the variable JSON array of collections complex values into a CSV file. I show you a workaround that may happen to you if you try to stuff a collection into a CSV file. You have to extract the values out of the collection into a set variable and use those instead on the CSV aggregator.
Next we move on to the variable JSON array of collections of really complex values and I show you how to use various array functions like map(), get(), first(), last(), merge() to extract valuable information from an array that has 2 sub arrays of 2 complex data structures. I also show you how to there can be subtle differences in array structures (1 element with multiple key/value pairs in 1 collection vs multiple elements each with their own key/value pair). The subtle difference can cause some grief because the Make UI doesn’t really let you pick the values so you do have to type out the reference using object paths (ie dot notation).
Download the Make blueprint and use the Import Blueprint to create a new scenario:
5. Manipulating Data Structures with CSV aggregator and array functions.json (80.4 KB)
–
Alex Sirota
Director of NewPath Consulting - we are 
Make Heroes! 
Check out my series of videos and scenario walkthroughs for Make Newbies