topic Re: [Help]Delete Rows with a specific value in Talend Studio

[Help]Delete Rows with a specific value

Anonymous — Sat, 16 Nov 2024 13:22:33 GMT

good morning..
i'm sorry for my bed english but i'm italian!
i have another problem
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)
label(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

Re: [Help]Delete Rows with a specific value

Anonymous — Wed, 30 Jun 2010 19:59:10 GMT

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.

Re: [Help]Delete Rows with a specific value

Anonymous — Thu, 01 Jul 2010 14:36:29 GMT

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.
Remi

Re: [Help]Delete Rows with a specific value

Anonymous — Thu, 01 Jul 2010 15:50:17 GMT

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