COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: aliclowes on 05 Jan 2018 07:09:44 AM

Title: Text file delivery to different files
Post by: 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
Title: Re: Text file delivery to different files
Post by: MFGF on 05 Jan 2018 07:48:36 AM
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.