How can I extract to a list of items from a list of bundles

Hi
I get a list of bundle
in every bundle I have an object of fields
How can I extract this data to a list of fleds (extract only the field called short_name)


as you can see in the image: short_name

“פתיתים אפויים כוכבים”
So it’s mean I want to take all the field name called “shor_name” and extract it to another modle and give it a name - for example - myItemList

Someone? :slight_smile:

1 Like

Not sure if you need a text list or a bundled list so will give you both.

To get the text list you can use the text aggregator:

If you need a bundle of them you can use split on your row separator:

ברוכים הבאים

@Mr.Make
Can you help me what do I need to put in JSON module and what do I need to put in Tools module?



I didn’t understand

1 Like

@Mr.Make
What do I need to put in JSON string?


I get the this result:

1 Like

You don’t need to use the parse JSON.

I used it so I can get an example of your data. Imagine the parse JSON as your postgreSQL module are the same.

@Mr.Make
In the Tools module - (Set Variable)
This is what I got:


I want to group by phone number with all his products
For example:
For phone number: 0506611762 all the values will be the items that you see.
I mean collection of [key, value] where key is the phone number and the value is list of customer’s items
Can I do it?

1 Like

You asked this “So it’s mean I want to take all the field name called “shor_name” and extract it to another modle and give it a name - for example - myItemList”

That is what that is if you need another problem solved create a new thread.

Thank you - I will do that :slight_smile:

1 Like

Hey @barak_Hazan1

You should use “array aggregator” for this. There you can group by phone number.

Regards,
Msquare Automation - Gold Partner of Make
@Msquare_Automation

1 Like

Thanks just to help keep the community clean and if people need to find other questions to help them it makes it easier than having multiple on a thread.

4 Likes