How can I resolve comma-separated data?

[learn2]

What is your goal?

think I need a module. to add comma- separated values together

What is the problem & what have you tried?

I have two shipping charges they come from a E commerce order but I need to join them together

Screenshots (scenario flow, module settings, errors)

[Stoyan_Vatov]

Hey there,

usually you can manually add the values one after the other with a comma between them. Or are you looking at an array of items? Then you can use the join() function to turn the array in a comma separated list.

[learn2]

@Stoyan_Vatov

manually add the values one after the other

just manually add the values one to the other

[Daraima_Bassey_N]

Hi @learn2

Please would you mind providing more context? Does both shipping charges live in the same sheet? Do they come from the same data bundle?

If yes then you’re going to need a join() formula with both shipping charges inside the bracket separated by a comma.

If both shipped charges come from distinct data bundle then you might want to try an aggregator module if joining them doesn’t work with join().

But from the image provided I can see that the data already lives inside your sheet so a join () will probably work. From the image I can see you’re trying to use a router. Routers rather direct values to a branch based on some criteria, not bring them together.

[learn2]

@Daraima_Bassey_N

Does both shipping charges live in the same sheet? Do they come from the same data bundle?

yes and yes I need a join formula, they come from this sheet

the reason I put a router in there is that later on I want to add. two filters or branches

[Sonia_Flynn]

yeb lern2

thank you

[Stoyan_Vatov]

So you want to get the data in the K column in a comma separated list?

Have the search module pull all the rows and then follow it with a text aggregator module. Inside set the separator to comma and map the K column as the value.

[Daraima_Bassey_N]

Great context. @learn2

thanks for the clarification. Your sheet makes it a lot clearer. One last question: the two charges you wish to bring together, are they from the same row in your sheet?

If yes then you can use get a row, pull that row and use join () to map the cell you want to bring together. If they are in different rows use search and pull the rows you need, use a text aggregator to bring the two required values together.

[learn2]

@Daraima_Bassey_N

use join () to map the cell

yes the two are in the same row and same cell, as in that shot…so I want to pull that row but then I don’t know how to do the next step

[samliew]

@learn2

so I want to pull that row

The row’s data should already be “pulled” when the trigger module detects new rows.

@learn2

It looks like cell K is already in a comma-separated list.

Do you mean to SUM both values together instead of JOINING them?

To do this, you can use these built-in functions:

• split
  split(text; separator)

• sum
  sum([array of values]), sum(value1;value2; ...)

Here’s an example of how you can use these functions together:

{{ sum(split(1.`10`; ",")) }}
_{Make Input Markup:}
        ^{Copy-paste the above into the field, including start/end curly brackets for it to import as intended}

e.g.:

Hope this helps! If you are still having trouble, please provide more details.

— @samliew

[learn2]

sam I have decided to forget the shipping value in that cell because I make going to manually check the final invoice and it will be easy to add then…Thanks so much for help anyrate

[Keenens]

Thank you for sharing.