You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Simple numeric field validation
#1 2012-06-21 19:18:18
- howie911
- New member
- Registered: 2011-12-05
- Posts: 3
Simple numeric field validation
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.
Offline
#2 2012-06-25 04:04:19
- pedro
- Member
- Registered: 2011-11-17
- Posts: 3682
Re: Simple numeric field validation
Hi
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.
Regards,
Pedro
Only Paranoid Survive.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Simple numeric field validation