ETL and Data Integration tools - Modern ETL software for everyone

Hello,

I trying to migrate some data from one MySql database to another.
The host database is a badly design database with a lot of invalid data. For example, the orders table has
Order_Number(PK) but any type of character could be entered into the column.

I am trying to move data to a new database which the Order_Number field only allows Numeric values.
Now while most values in the old database are in the format of '1234567' there are some rows of data that are corrupted for example 'First Order' and '2XM/56'.
As these orders are not used, I am trying to work out how to bring across only the valid rows of data where the values actually match the integer format and skip any other invalid data.

Any suggestions or directions would be great.
thanks,
ISa

This is actually very simple

Use validator together with IsNumber function

All bad data will be rejected or redirected to different data stream

See attached file

Mike

All works as expected now

Thank you for your time

ISa