We recommend switching to the latest versions of Edge, Firefox, Chrome or Safari. Using Internet Explorer will result in a loss of website functionality.

Output to multiple, then to excel

Comments

3 comments

  • Avatar
    Infogix Support
    Originally posted by: gmullin

    You'll have to make use of 2 things:

    1. The Do While node to cycle through each set of data you want in an individual Excel file. Write the data out to some common name, let's say temp.xlsx, then you will rename the file to something more useful on each iteration (point 2).
    2. Each time you write out the file "temp.xslx", you will want to clock it to a Filter node and make use of the moveFile() command to rename the file to something like the filename you mentioned above.
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: darrenhoggard

    Ok, so I have done the following:
    Summary of the the 4 fields, this creates 8 records, so therefore i need to loop through the main data 8 times.
    this goes into the do while loop as initial input
    output to loop goes to a filter where first exec - this then goes into a x-ref with the main data which matches on the 4 keys and outputs to excel
    the output to loop also goes to another filter where not first exec - so there will now be 7 records - how do i tell the loop to stop when there are no records left?
    0
    Comment actions Permalink
  • Avatar
    Infogix Support
    Originally posted by: darrenhoggard

    No worries got it working, the not first exec seems to work as the input for the next loop, which reduces each time, just had to put a timer on the excel output to stop the loop from starting until it had finished the current loop.
    0
    Comment actions Permalink

Please sign in to leave a comment.