Forum management
- Threads started by me
- Threads I participate in

Developer forum

Ignoring an invalid row in a table script

Scott Forsyth

Posted on 16/06/2018 18:37:22

Hello,

I'm creating some Table Scripts and there are times when the row from the source isn't a valid row. I would like to have that be ignored rather than entering the data from the invalid row. What's the best way to null out or invalidate the row in the ProcessInputRow method so that that particular row can be ignored?

Thanks,

Scott

Replies

Morten Bengtson

Posted on 18/06/2018 09:39:11

Hi Scott,

You might be able to exclude the rows by using conditionals.
In the ProcessInputRow method of your TableScript you can set a column value to something invalid (SomeColumn = "-1") and then use a conditional to exclude the invalid rows (SomeColumn <> "-1").

Best regards,
Morten

Scott Forsyth

Posted on 18/06/2018 16:14:32

Hi Morten,

That's a good idea. I'll give it a try, thanks!

Scott

You must be logged in to post in the forum