Read only integer value records from a table.

[mac4rfree85]

Hi Guys,

I am reading data from SAP table. I need to read only those records which are having numeric value in a paritcular column.

So, i used int(Col name) in the derivation. please guide me if i am correct. Because i am getting an abnormal termination error and the jobs gets failed. So, unable to test the job.

Can somebody point me in a right direction.

Cheers!!!

[ray.wurlod]

Use Matches operator in a constraint expression.

Code: Select all

InLink.TheValue Matches "1N0N"

If you might need signed integers, extend the pattern.

Code: Select all

InLink.TheValue Matches "1N0N" : @VM : "'-'1N0N" : @VM : "'+'1N0N"

[chulett]

Reset the aborted job and let us know the contents of any 'From previous run...' log message that shows up.