# Separating parameters from a list to individual fields

**URL:** https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277
**Category:** Questions
**Tags:** wordpress, google-sheets, arrays, mapping
**Created:** [February 13, 2024, 6:03am UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277 "2024-02-13T06:03:56Z")
**Posts on this page:** 14
**Page:** 1

<div class="post-metadata">

### Author: ![floripaolo](https://avatars.discourse-cdn.com/v4/letter/f/35a633/32.png) [@floripaolo](https://community.make.com/u/floripaolo)
#### Post date: [February 13, 2024, 6:03am UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/1 "2024-02-13T06:03:56Z")

</div>

Hello

I am reading a list of numbers (comma separated) from a cell in Google sheets and I need to insert them individually to create a WP post.

Additionally those tags can vary in number. They can sometimes be 2, 3 or 4 (like in this case).

 ![Screenshot 2024-02-13 at 06.58.59](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/0/b0dea2c152a8f974a7db1e53d1878eaf7af1833a.png)

Thanks

---

<div class="post-metadata">

### Author: ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)
#### Post date: [February 13, 2024, 7:00am UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/3 "2024-02-13T07:00:44Z")

</div>

Use `{{ split(11.`D`; ",") }}` in an iterator.

Use an array aggregator to map into the Values field (Turn on the “Map” toggle)

Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.

[Aggregators](https://www.make.com/en/help/modules/aggregator.html) are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the [Array aggregator](https://www.make.com/en/help/tools/flow-control.html#array-aggregator) module. The next popular aggregator is the [Text Aggregator](https://www.make.com/en/help/tools/tools.html#text-aggregator) which is very flexible and has applies to many use-cases.

### Read this

The Array Aggregator module allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it.

Here is an example of using the “Target structure type” of an Array Aggregator module:

 ![Screenshot_2024-01-17_100113](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/e/bea4ecffec9daf39ca9cba77c0b2a40d160e7292.png)

As you can see, the “Map” toggle on fields are used when you have an array. You can easily build an array variable to map to a field, by using an Array Aggregator module and select the “Target Structure Type” as the future field you want to map the array into.

---

<div class="post-metadata">

### Author: ![floripaolo](https://avatars.discourse-cdn.com/v4/letter/f/35a633/32.png) [@floripaolo](https://community.make.com/u/floripaolo)
#### Post date: [February 13, 2024, 8:56am UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/4 "2024-02-13T08:56:01Z")

</div>

HI

Thanks for that!

I’ve setup the aggregator, but I seem not to be able to map the actual data into the fields.

I tried mapping the arrays, the values, with numbers or without, but I always get an error message.

 ![Screenshot 2024-02-13 at 09.46.42](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/6/f62bd1e569afd062cd6a1fdf6772a37e3ed963ff.png)

 ![Screenshot 2024-02-13 at 09.47.01](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/1/51444b053fe3720ddb4e81efc49098be9c5242fa.png)

![Screenshot 2024-02-13 at 09.54.26](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/3/83a41608992d222dd3c0cf549264ea8cf6529ca2.png)

Or by mapping:

 ![Screenshot 2024-02-13 at 10.03.10](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/e/feeb5aca9da01ec9a31ac6a3d24171e0ef8d7eec.png)  
 ![Screenshot 2024-02-13 at 10.12.11](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/e/1ef2fb44ebf27b1169410782723a19a0a4b49f31.png)

---

<div class="post-metadata">

### Author: ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)
#### Post date: [February 13, 2024, 10:03am UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/5 "2024-02-13T10:03:54Z")

</div>

Okay, looks like you don’t need an iterator or aggregator.

Just `{{ split(11.`D`; ",") }}` directly into the Values field.

![Screenshot_2024-02-13_180244](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/c/fc558477f7ea92f0f214bda34c5864b2e9812ea2.png)

---

<div class="post-metadata">

### Author: ![floripaolo](https://avatars.discourse-cdn.com/v4/letter/f/35a633/32.png) [@floripaolo](https://community.make.com/u/floripaolo)
#### Post date: [February 13, 2024, 10:32am UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/6 "2024-02-13T10:32:46Z")

</div>

Thanks but I keep getting an error.

 ![Screenshot 2024-02-13 at 11.32.07](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/a/0/a00f2111c17ab2c81f76a74e8929ad1f2b022df5.png)  
 ![Screenshot 2024-02-13 at 11.32.23](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/4/947480dafbd8083533a08c2b0657478cbf35b906.png)  
 ![Screenshot 2024-02-13 at 11.32.35](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/0/5/0504a2b01ea20100b0ed5e2bb40ce49b5576897b.png)

---

<div class="post-metadata">

### Author: ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)
#### Post date: [February 13, 2024, 11:01am UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/7 "2024-02-13T11:01:30Z")

</div>

Your error comes from the other field, playlist, which is empty.

---

<div class="post-metadata">

### Author: ![floripaolo](https://avatars.discourse-cdn.com/v4/letter/f/35a633/32.png) [@floripaolo](https://community.make.com/u/floripaolo)
#### Post date: [February 13, 2024, 11:17am UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/8 "2024-02-13T11:17:30Z")

</div>

Right!

Now the tags work! Thank you!!

And I have an additional problem: playlists can be empty. how do I make ignore it and just leave the field empty?

---

<div class="post-metadata">

### Author: ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)
#### Post date: [February 13, 2024, 12:43pm UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/9 "2024-02-13T12:43:50Z")

</div>

You can use the built-in function `ifempty` with `emptystring`

e.g.:

```plaintext
{{ ifempty(variable; emptystring) }}

```

For more information, see

## Links

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 —

### General

- [Help Center](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html)
- [Make Academy](https://academy.make.com) – learn Make and get your certificate **← CHECK THIS OUT**
- [Make Blog](https://www.make.com/en/blog) – get the latest updates
- [Features & Pricing](https://www.make.com/en/pricing)

### Help Center Basics

- [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map?
- [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array
- [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output)
- [Tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [Tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting)
- [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file
- [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks

### Articles & Videos

- [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube
- [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist
- [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796)
- [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202)

---

<div class="post-metadata">

### Author: ![floripaolo](https://avatars.discourse-cdn.com/v4/letter/f/35a633/32.png) [@floripaolo](https://community.make.com/u/floripaolo)
#### Post date: [February 13, 2024, 3:31pm UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/10 "2024-02-13T15:31:56Z")

</div>

H @samliew

Thanks for those links. I started the Academy a few days ago…

I actually came up with that same expression, but it doesn’t work for some reason… 🙁

 ![Screenshot 2024-02-13 at 16.27.07](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/9/2985a438ac973137660a988105bd22a1121557f4.png)

I still get the same error message:

- Missing value of required parameter ‘values’.

---

<div class="post-metadata">

### Author: ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)
#### Post date: [February 13, 2024, 3:40pm UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/11 "2024-02-13T15:40:34Z")

</div>

Instead of emptystring, try:

- ignore

- space

---

<div class="post-metadata">

### Author: ![floripaolo](https://avatars.discourse-cdn.com/v4/letter/f/35a633/32.png) [@floripaolo](https://community.make.com/u/floripaolo)
#### Post date: [February 13, 2024, 3:50pm UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/12 "2024-02-13T15:50:28Z")

</div>

🙁

None of them work…

![Screenshot 2024-02-13 at 16.47.22](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/c/ec0bcd33ff9a65ee92bfc8a1a69462b486e9ff29.png)

 ![Screenshot 2024-02-13 at 16.50.03](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/4/d4fe2f228a9125fbb718c31e13a0845b36fe1ae8.png)

 ![Screenshot 2024-02-13 at 19.32.39](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/3/e37ce5217e6810f3896ea26db2d3d939f00c0ba0.png)

---

<div class="post-metadata">

### Author: ![D\_Sparrow](https://avatars.discourse-cdn.com/v4/letter/d/77aa72/32.png) [@D\_Sparrow](https://community.make.com/u/D_Sparrow)
#### Post date: [February 15, 2024, 12:27am UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/13 "2024-02-15T00:27:53Z")

</div>

Ive come across this error. Un-map (turn off mapping) that field so it is NOT updated. Now, add a New Update Wordpress Post module, this will only update 1 thing, can you guess? Now connect it to the original one but with a Filter that blocks the flow IF that variable IS Empty. HTH.

---

<div class="post-metadata">

### Author: ![floripaolo](https://avatars.discourse-cdn.com/v4/letter/f/35a633/32.png) [@floripaolo](https://community.make.com/u/floripaolo)
#### Post date: [February 15, 2024, 7:47am UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/14 "2024-02-15T07:47:32Z")

</div>

Nice workaround!!  
Thanks a lot!!

---

<div class="post-metadata">

### Author: ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [February 29, 2024, 8:32am UTC](https://community.make.com/t/separating-parameters-from-a-list-to-individual-fields/27277/15 "2024-02-29T08:32:11Z")

</div>


