This was great. I especially liked the vlookup piece. I had spent hours trying to figure out the iterator and text aggregator myself, now I am stuck on the vlookup piece ofr multiple different product ID's. Your video was really helpful.
HI Daniel, I was wondering if you can give me an idea I have 2 arrays both have date array1=[{ "name": "jhon doe", "city": "New-york", "date": "2022-11-15", "salary": 3000, "departement": [ IT,Finance]] },]. and the second one is. array2 =[ { "date": "2022-11-08", "has_bonus": "no" }, { "date": "2022-11-08", "has_bonus": "yes" }] they oth have 25 rows. i want to make a new array =[{ "name": "jhon doe", "city": "New-york", "date": "2022-11-15", "salary": 3000, "has_bonus": "no" "departement": [ IT,Finance]] },]. the problem is my solution is consuming so much operation i want to reduce it to lesser operations can you have an idea ?
It's hard to write up here. But I guess you will always need to iterate through one, then do first(map(...)) in a "Text Aggregator" where you create a custom JSON or in "Aggregate to JSON" to find your "has_bonus" right after the Iterator. This is a little complicated. Then you will just do "Parse JSON" to convert everything to the "Make array object"
This is gold! God bless you, Daniel!
I was looking for just this thing! Thank you
This was great. I especially liked the vlookup piece. I had spent hours trying to figure out the iterator and text aggregator myself, now I am stuck on the vlookup piece ofr multiple different product ID's. Your video was really helpful.
Maybe try academy.make.com :)
HI Daniel, I was wondering if you can give me an idea I have 2 arrays both have date array1=[{
"name": "jhon doe",
"city": "New-york",
"date": "2022-11-15",
"salary": 3000,
"departement": [ IT,Finance]]
},]. and the second one is. array2 =[ {
"date": "2022-11-08",
"has_bonus": "no"
}, {
"date": "2022-11-08",
"has_bonus": "yes"
}] they oth have 25 rows. i want to make a new array =[{
"name": "jhon doe",
"city": "New-york",
"date": "2022-11-15",
"salary": 3000,
"has_bonus": "no"
"departement": [ IT,Finance]]
},]. the problem is my solution is consuming so much operation i want to reduce it to lesser operations can you have an idea ?
It's hard to write up here. But I guess you will always need to iterate through one, then do first(map(...)) in a "Text Aggregator" where you create a custom JSON or in "Aggregate to JSON" to find your "has_bonus" right after the Iterator. This is a little complicated. Then you will just do "Parse JSON" to convert everything to the "Make array object"