get name column

One Star

get name column

hello Smiley Wink
(sorry my english is not perfect........I still learning)
can I get the name of a some columns instead data in a tmap?
I need this name to find this in other table(validation table) and get the values max and min and compare (validate) the data of this field..
or...
how can I make a query in a function (in ROUTINES) with two parameters, to use this VAR space on a tmap, and this to return the MAX value or MIN value that I need?

regards Smiley Happy
Community Manager

Re: get name column

Hello
can I get the name of a some columns instead data in a tmap?

See the related 6441.
how can I make a query in a function (in ROUTINES) with two parameters, to use this VAR space on a tmap, and this to return the MAX value or MIN value that I need?

You don't need to use Var space,
assuming your job like: tFileInputDelimited--row1-->tMap--->tMysqlOutput, type in the following code in the expression field of output column:
RoutineName.methodName(row1.param1, row1.param2)

Feel free to post your questions on forum!
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: get name column

mucho thanks Smiley Happy ...............
now I have another question............... how do I get the name, or reason of why it was rejected and save this, in a filed in my rejected table.......because there are a lot of fields, and I want to get the error field......
regards.....
One Star

Re: get name column

Hi Shong,
What about column length. How to retrieve column length?
Thanks in advance.
Community Manager

Re: get name column

Hi Shong,
What about column length. How to retrieve column length?
Thanks in advance.

Hi
Why would you like to retrieve the column length? Can you explain a bit for your request?
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business