[Help]Delete Rows with a specific value

One Star

[Help]Delete Rows with a specific value

good morning..
i'm sorry for my bed english but i'm italian!
i have another problem Smiley Sad
i have a sql database and an excel file both for input. with a t_map i obtain the rows that i want from the file and the db. the problem is after.
with the t_map i have obtainde this like output:
model_id (short number)
descr (string)
now i would keep only the rows with a value=0 and put this in outputexcelfile but i haven't understand what i must do!
in my file i have either the value difference from 0 either values =0;i have tried with replace but is not correct because i don't must replace a value but keep only a value.
either with filter and aggregate i am not able to obtain that i want so please help me!!!
thanks in advance
One Star

Re: [Help]Delete Rows with a specific value

Can you post a picture of your job? It would help to understand what you are trying to do.
Google Translate:
Puoi inviare una foto del tuo lavoro? Aiuterebbe a capire ciò che si sta cercando di fare.
One Star

Re: [Help]Delete Rows with a specific value

Hello chira8,
I am not to sure to understand your question. Is "value" a variable in your input row? Or you mean it is the value of model_id...
From what I understood, what you could do is set the condition value == 0 in your tmap output as shown in this picture.
Hope this helped.
One Star

Re: [Help]Delete Rows with a specific value

ok put value in the map == 0 works Smiley Happy
thanks a lot

Cloud Free Trial

Try Talend Cloud free for 30 days.


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.