Excel Comma Separated string to Array Field in 'Update' Module

[Nick_Trautman]

I think I might be making this more difficult that it maybe should… So in it’s simplist form, I have two related scenario’s. The first one, goes out to the data source, pull product information down, including ‘Tags’. The ‘Tag’ field is an array and can vary from a single ‘Tag’ to up to 7 or 8 ‘Tags’. I use an Array Aggregator to insert them into one cell, with the intention they can then be split and inserted back into the source module.

So here inlays my issue… From the Excel File, I’m running an Iterator with the following Array
“{{split(5.row.d.text; “,”)}}”, in attempt to split the comma separated values into an array. When seperated they need to be inserted into the source module shown in the attachment.

[Nick_Trautman]

Maybe it was simpler than I expected. I ended up bypassing the iterator and simply added “{{split(5.row.d.text; “,”)}}” directly into the field and it seemed to work.

[samliew]

Welcome to the Make community!

You can use the built-in function split to create an array from a delimited string.

e.g.:

{{ split(1.text; ",") }}

For more information, see the split function documentation in the Help Center and do the tutorials in the Make Academy.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

• Help Centre | Tutorials – Make “Manual”
• Make Academy – Basics 101: Learn Make and get certified

Help Centre Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
• How to use Regex in Make - How to use pattern matching to extract the text you want
• Webhooks – Make Academy – tutorial on how to use Webhooks

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.