Reject

[I_Server_Whale]

Hi All,

I have blank rows of data in a table I'm accessing. How do I reject these rows? Is there any in-built GUI function which does this or do I have to mention it in the constraint?

Your help is very much appreciated,

Thanks,
Naveen.

[pnchowdary]

Hi NaveenD,

As far as I know, there is no such in built GUI function in server jobs that lets you skip blank rows.

Therefore, I think that you need to use some sort of constraint to achieve it.

There are a lot of ways you can achieve this, one way to do it is to check the length of a key column after trimming the spaces and send the row to the output only if its greater than zero.

Code: Select all

Len(TrimB(InLink.InCol)) > 0 

[ray.wurlod]

It might be interesting to ask how they got in there in the first place.

The easiest thing to do is to filter them out when extracting - add another WHERE condition in the SQL so that "blank rows of data" (whatever that means) are not selected.

[vmcburney]

I would filter them out in the initial SQL select if you don't want them involved in your job in any way, I would filter them out in the job via a constraint if you don't want to process them but you want to write them to a reject file for data quality investigation.