If you are unable to create a new account, please email support@bspsoftware.com

 

Text file delivery to different files

Started by aliclowes, 05 Jan 2018 07:09:44 AM

Previous topic - Next topic

aliclowes

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

MFGF

Quote from: aliclowes 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

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!