DSXchange

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.

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.

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.

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.