Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.
Originally posted by: martinh1976Hi
Was wondering whether anyone could provide examples of how the Do While node works.
I have a file which I want to generate an excel output based on a dynamic read of values in a particular column e.g. Customer.
Each corresponding row in the input file i wish to place into its own excel workbook.
I have managed to do it using a Filter node which generates multiple output Pins which in turn have a connected Output Excel node - but this is very messy and no dynamic enough when new values are added.
Any help appreciated. Attached what I have so far.
multipleoutputtoexcel.brpmultipleoutputtoexcel.brg
Thanks
Martin