How to Skip row where column value character lenght is more than 50 char

Six Stars

How to Skip row where column value character lenght is more than 50 char

i loading a file data to ms sql db. 

some times the value of a a row is too long char. How can skip this row and let other rows to enter. 

I have also unchecked the die on error box.  

 

example 

name, value, store

item1,44,AC

asdnonasc238712847kcnn,44,GH  <-------- ignore this row  from insert 

item3,67,FD


Accepted Solutions
Forteen Stars

Re: How to Skip row where column value character lenght is more than 50 char

@amtkmr1990 ,you can use below way.

 

StringHandling.LEN(row2.ename)<=50

 

Untitled.png

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

View solution in original post


All Replies
Forteen Stars

Re: How to Skip row where column value character lenght is more than 50 char

@amtkmr1990 ,you can use below way.

 

StringHandling.LEN(row2.ename)<=50

 

Untitled.png

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

View solution in original post

Six Stars

Re: How to Skip row where column value character lenght is more than 50 char

Thanks, I will try it.

And hwo to display or mail the skip rows ?.

Forteen Stars

Re: How to Skip row where column value character lenght is more than 50 char

@amtkmr1990 , you can catch the output rejects by using below way and can write to a file or DB or tLogRow, 

 

Untitled.png

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: How to Skip row where column value character lenght is more than 50 char

do i ned to uncheck or check the "Die on error " box of mssqloutoput ?

Forteen Stars

Re: How to Skip row where column value character lenght is more than 50 char

@amtkmr1990 no need to uncheck and the same error should not come on the same field.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog