You are not logged in.
Using Talend Open Studio 5.0 with a simple task: read a MSSQL Server table, and validate one column for numeric data. Send all valid rows to one output file, all non-numerics to a reject file. For the life of me, I can't figure out if I should use a component for this test (tMap, tFilterRow?) or do I use the expression editor to do the validation? Slightly lost on a TOS 101 issue. Thanks in advance.
According to your description, you might user the advanced mode of tFilterRow to get 'Filter rows' and 'Rejected rows'.
Use regex expression to validate the column for numeric data.