We are importing a table with a variable number of rows from Parseur, BUT how do we specify the Data Output array, so that all rows are created. Currently we can only create a file which shows the correct number of [containers] , but only details for one of the rows – see below
Use an iterator and map the values from that.
Thanks. We are alrwady using arrays. Two. 1 header and 1 detail array. The Detail array consists of variable rows. We also have an Iterator module between the Parseur and FTP modules.
However neither we or “support” have been able to extract more than the first row in the detail table.
There must be a command which manages the fliw of data in arrays consisting of multiple rows. But what is it.
Support tried " merge" on both arrays, but that had zero effect on the outcome.
Can you provide a screenshot of what your scenario looks like?
1 Scenario.docx (301.3 KB)
Hi thanks for replying. Attached should be a word doc with pics and text. Essentially everything is fine, until th eFTP stage.
Your mapping the values for the FTP fields from the parsuer. You need to map them from the iterator module. That is why you are getting the 1st row of data only.
So ulitimately how do you want the file to look? From your current setup your creating an excel file for each order item to be uploaded. Is that correct?
1 Like
Hi, First thanks for your help.
Pointing me to the Iterator output instead of Parseur, was a life saver !
You are correct, I am hoping to have only one instance of the Header (Customer) Fields, which are not part of the Detail array, followed by the Detail array rows ( Items ordered). Pic below which I hope is clearer.
However having struggled all day, I clearly need some more help. Please.
Once again. A big thank you
All the best
Mike
After your iterator you need to add in an aggreagtor to combine all the bundles into a single output.
I suggest using a text aggreagtor. If you don’t have much experience with using an aggregator I suggest you take a look at the Make learning modules. It’ll be a good investment in your time and will help you increase your use cases for Make.
Hope this helps!
Hi, Thanks for your reply. I added the Aggregator but ended up with the same output. I have labeled the rows with an H and a D in the image below, The data is correct. But I only wish the row marked H to be shown once. As the data is the same on all repeated instances.
What does your scenario look like with the aggregator? Perhaps omit the headers from the text aggregator and map the headers from a previous step above the aggregated text in the ftp module.
1 Like
Thanks. Used 2 ftp modules and then appended the output of the last to the first. Creating one file with Header and Detail lines.