Multiple Output files based on variables

Question

I have a data file with 44,000 records/transactions for 30 Manufacturers.  I have designed my output file and I currently change the Manufacture Code (using Filter), incorporate the Manufacture Code in the filename, and then "Run".  However, is there a way I can run the process, selecting the 30 different Manufacturer codes and Run to produce all 30 reports simultaneously, but saved separately?

Jonathan-Sherman · Accepted Answer

Hi @KSassone,

you could tick the checkbox at the bottom of the configuration pane of your output tool to “include file name as field”. And add your manufacturer field as a suffix or prefix to the file name you choose. This way your data will be “grouped” and outputted into separate excel files (if that’s the file type you choose).

If this solves your issue please mark the answer as correct, if not let me know!

Jonathan

RWvanLeeuwen · Accepted Answer

@KSassone

The approach of @Jonathan-Sherman should be suitable for you. Please accept it as a solution so others can find the answer as well and as quickly as possible.

Best,RolandInfotopics - Benelux partner of the yearEmpowering business through analytics. See, Understand, Act!