I want to have all separate topics in their own row not everything in one row. I have configured in OpenAI text to structured data have the parameters as array of text because otherwise only the first topics would pass through however now instead of various rows in excel for each topic and their link they all mash into one row
OpenAI text to Structured Data:
OpenAI Chat Completion:
Looks like the results are in arrays.
When you see an ARRAY, think ITERATOR.
You need an iterator module, otherwise if you want to map all the array items in the same operation, see Mapping with Arrays in the help centre.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
How do I map this correctly, I tried looking at the help centre but still don’t understand. The iterator only provides one output to give to excel. So how can i Do that for all for parameters.
This does not seem to work because only one value can be taken from iterator to excel
And even when i tried it with headline for instance my excel only came out with the first headline and not multiple rows for all the other topics, URLs, etc
You selected the wrong variable to map in the Iterator module.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
I tested it once with only the headlines and it worked nicely giving each headline in a seperate row. However, now when I created one for each it did something absurd. It just kept going creating endless rows. There are 15 topics so 15 links and 15 summaries for each respective topic and so on. What happend;
Don’t know how they all can give such different outcomes when configured similarly. I just want the excel sheet to be as long as the array (15) with each row having its distinct source, headline, summary and link.
Next hint: You only need to Iterate one of the arrays.
The other three array values can be retrieved using the Bundle order position variable from the Iterator module.
Of course, all this would have been easier resolved if the data structure of your OpenAI module is done properly.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
I feel abit stupid maybe but how is that supposed to work because now headlines are correctly mapped in their seperate row but with “Bundle Order Position” I just get numbers for the other values?
I think I get what you meant now @samliew
I’ve asked to give the output into a JSON format and by parsing I get it all in nice bundles which can then be seperated and put in excel. Still wondering if this would be possible with OpenAI text to structred data beacuse that put all info into seperate parameters instead of bundles with the different parameters for each
Yes this is possible. How are you currently doing it with the Transform text to Structured Data module?
To allow us to assist you with your scenario, please provide the following:
Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
Following these steps will allow others to assist you here. Thanks!
No so I previously used the “Text to Structured Data” module in this scenario:
Newsletter #1.json (43.1 KB)
However, with “Text to Structured Data” it would create separate parameters for the 4 things I was looking (headline, source, summary, URL link) and putting all the data it found of that in each parameter which wont work with “Iterator” as it is not a bundle of the 4 things per topic found in the newsletter. So this scenario I’ve taken “Text to Structured Data” out and given chat a JSON example to put all info into separate bundles with the iterator can they take the array apart and put nicely back into Excel.
Newsletter #2.json (35.2 KB)
You should have done it like this instead:
This is just an example. Your final solution may or may not look like this depending on your requirements.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
Is doing this with the module “Text to Structured Data” better or more accurate than using “Create Prompt Completion” and giving it a JSON example and using Parse JSON module for the iterator?
Anywho Thanks again @samliew you really are the make solution maestro
No problem, glad I could help!
1. If anyone has a new question in the future, please start a new thread. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely.
2. The Make Community guidelines encourages users to try to mark helpful replies as solutions to help keep the Community organized.
This marks the topic as solved, so that:
To do this, simply click the checkbox at the bottom of the post that answers your question:
3. Don’t forget to like and bookmark this topic so you can get back to it easily in future!
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!
