Author Topic: Text file delivery to different files  (Read 870 times)

Offline aliclowes

  • Full Member
  • ***
  • Join Date: Jan 2010
  • Posts: 11
  • Forum Citizenship: +0/-0
Text file delivery to different files
« on: 05 Jan 2018 07:09:44 am »
HI

I am running a sql query, which returns a number of columns one of which is nominal, I would like to output to different csv files, one for each nominal is this possible ?

thanks

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,217
  • Forum Citizenship: +620/-10
  • Cognos Software Muppet
Re: Text file delivery to different files
« Reply #1 on: 05 Jan 2018 07:48:36 am »
HI

I am running a sql query, which returns a number of columns one of which is nominal, I would like to output to different csv files, one for each nominal is this possible ?

thanks

Hi,

You would need to define multiple text file deliveries for your build, each for a different nominal code, then add output filters to each so that only the rows for the appropriate nominal code are delivered.

Cheers!

MF.
Meep!

 


       
Twittear