EZ Exporter Update: New Function for Combining Lists/Arrays
We've just added a new function called join_lists() to our EZ Exporter app.
This new function will allow you to combine values from two separate lists where you can specify a separator between values and also between group of values.
For example, you might have the following lists of values on your Shopify store:
# Lineitem Tax Lines - Titles (line_items.tax_lines.title) NY State Tax,New York County Tax,New York Municipal Tax # Lineitem Tax Lines - Rates (line_items.tax_lines.rate) 0.04,0.00375,0.045
Using the join_lists() function will allow you to combine these values in one field, where you can specify a separator between matching items (defaults to ": ") and the group of items (defaults to ", ").
Using this formula:
join_lists(to_list({{ line_items.tax_lines.title }}), to_list({{ line_items.tax_lines.rate }}))
Will output:
The function requires a "list" data type so we used the to_list() function here to combine the comma-separated list of values into a "list" data type first.
If we want to use a different value separator, we can specify this in the function's value_separator parameter. Let's use the separator " -> " here:
join_lists(to_list({{ line_items.tax_lines.title }}), to_list({{ line_items.tax_lines.rate }}), value_separator=" -> ")
This will then output:
We can also override the group_separator using a "newline" (line break) character like this for easier redability:
join_lists(to_list({{ line_items.tax_lines.title }}), to_list({{ line_items.tax_lines.rate }}), value_separator=" -> ", group_separator="\n")
This will result to this:
Here's a more complex example where the formula parses the raw JSON output of the "Note Attributes" data and formats it in the form of "Name: Value" pairs where each pair is separated by a newline character. The values of the "name" and "value" attributes are collected first using the get_attribute_value() function and then passed in as inputs to the join_lists() function.
join_lists(get_attribute_value({{ note_attributes }}, "name", return_raw_results=True), get_attribute_value({{ note_attributes }}, "value", return_raw_results=True), group_separator="\n")
This will output:
This new function opens up some new ways of formatting list/array-type data on export from your Shopify store and we hope you'll find it useful!
Tags: new features, shopify, csv export, ez exporter