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

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Filtering Null Records.[Closed]

Started by Srik, 13 Dec 2006 08:17:01 PM

Previous topic - Next topic

Srik

Hello ,

I'm loading data from flatfile to database.

While this process i need to elimate all null records.

The null records which are elimated need to be written to a text file . and other records need to be loaded in the database table.

Can some one help me how to handle this issue.

Thanks,
Kanth.

MFGF

Hi,

The easiest way to handle this is probably to have two deliveries from your build - the first configured as a text file delivery, and the second as a relational table delivery.  Add an output filter to the text file delivery containing syntax such as
Field1 is null and Field2 is null and Field3 is null and...   (substituting the real field names for Field1, Field2 etc)
then check the 'Exclusive' checkbox for this delivery.

The build should then deliver the null records to the text file and the non-null records to the relational table.

Hope that helps!

MF.
Meep!

Srik