topic Re: [resolved] Create calculated field in Talend Studio

[resolved] Create calculated field

Anonymous — Wed, 22 Oct 2014 14:12:06 GMT

This is probably a simple thing to do, but I simply can't figure it out (newbie to TOS).
MSSQL connection -> tMap -> Vertica connection.
Source has 10 columns, but I want the target table to have 11 columns. The new column will have the count of rows with a CLOSE_DATE (one of the existing columns) per month. For example, I want to know the total number of tickets closed per month.
thanks

Re: [resolved] Create calculated field

Anonymous — Thu, 23 Oct 2014 16:33:52 GMT

On the output flow you see the 11 columns and if you click at the value field you can open the expression editor. Here is the place where you can calculate the value based on the input flow columns for the output column.
Actually your job design should looks like:
tMysqlInput --> tMap --> tVerticaOutput
You should build for both in the metadata section the table metadata, drag and drop both metadata into your job (use the mentioned components) and connect the input and output with the tMap.
Now open the tMap editor and connect all columns from the input to the output and for the last vertica column define the calculation expression.
This is actually a very beginner task and you will find a lot of help also as YouTube videos as well.

Re: [resolved] Create calculated field

Anonymous — Fri, 24 Oct 2014 12:51:18 GMT

worked!! thanks
p.s. what are the top 2 or 3 resources online for beginner/intermediate/advanced TOS training in your opinion?

Re: [resolved] Create calculated field

Anonymous — Fri, 24 Oct 2014 14:12:34 GMT

I strongly suggest a Talend training or you make your self familiar with it - I have done this - but you need Java skills to understand what happen to the job when you change some options. Without deeper Java skill the Talend training is the best option.
Books are not available so far - as I know.

Re: [resolved] Create calculated field

Anonymous — Fri, 24 Oct 2014 15:20:12 GMT

thanks @jlolling. There are some java skills in house, but i'm not one of them, so I'll choose the training

Re: [resolved] Create calculated field

Anonymous — Tue, 27 Aug 2019 07:36:05 GMT

My Input:

id,name,amount,Date
1,ABC,10000,13-03-2019
2,DEF,15000,13-02-2019
3,GHI,20000,13-01-2019

My Output:

id,name,amount,Date,TotalExpenses
1,ABC,10000,13-03-2019,45000
2,DEF,15000,13-02-2019,35000
3,GHI,20000,13-01-2019,20000

The total expenses should be previous amount + current amount