empty rows

One Star

empty rows

Hi,
I am having in my CSV file an empty rows which I do not want to output.
I would like to have in my CSV output the only rows with data.
I have use tjava row to find my empty row , I also use filter row to filter which one are emapty but still having in my output empty row .
Anyone can help?
Thanks
Zeljka
One Star

Re: empty rows

Just to add my real image AND my java code..
Z
Highlighted
One Star

Re: empty rows

Why not just check "Skip empty rows" in tFileInputDelimited?
You can't easily filter with tJavaRow. Use tFilterRow: in advanced mode you can use custom java code
Six Stars

Re: empty rows

Well... for such basic filtering just use a tmap with a filter expression.

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.