Best answer

Help generating new rows from CSV fields using formatter

  • 8 October 2020
  • 2 replies
  • 174 views

Userlevel 1

I am trying to transform shopify data so that multiple, comma separated values are reformatted as separate rows in a google sheet. 

 

For example a typical order with multiple line items might look like this:

Order Number Line Items Quantity
1001 item 1, item 2, item 3 1,4,1
1002 item 1, item 2 7,1
     

 

I am trying to use the Split Text formatter to out put the following in a google sheet:

 

Order Number Line Items Quantity
1001 item 1 1
1001 item 2 4
1001 item 3 1
1002 item 1  7
1002 item 2 1

 

The closest I’ve gotten is to have the individual items appear on a separate line within the same field. 

 

Any tips, examples, or points in the right direction to address this challenge would be greatly appreciated!

icon

Best answer by nicksimard 10 October 2020, 00:31

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Userlevel 7
Badge +11

Hi @flowjuggler!

The way you described it, I wasn’t sure if there were multiple orders coming in the same trigger data or if you were giving an example of two different times the Zap would have triggered (once for 1001 and another time for 1002). Assuming you’ve got line items for the things the person bought and the order number would be a separate field (not a line item) here’s how you could do it:

1) Make sure you select this action for Google Sheets:

2) Map the fields like this:

3) You’ll end up with something like this in Google Sheets:

As you’ll notice, the order number is added to each of the rows, while you’ve got one row per line item :)

Would you mind giving that a shot to see if that gets you what you need?

Userlevel 1

@nicksimard Thank you so very much Nick!  You correctly identified and solved the problem. I hope someday I bump into you at a bar so I can buy you a beer. Until then, enjoy a kitty. :smiley_cat: