topic get name column in Talend Studio

get name column

Anonymous — Sat, 16 Nov 2024 13:57:08 GMT

hello
(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

Re: get name column

Anonymous — Tue, 19 May 2009 02:36:28 GMT

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

Re: get name column

Anonymous — Wed, 20 May 2009 22:54:55 GMT

mucho thanks ...............
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.....

Re: get name column

Anonymous — Thu, 13 Dec 2012 04:13:53 GMT

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

Re: get name column

Anonymous — Fri, 14 Dec 2012 04:30:40 GMT

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