sum up values from input excel files from tmap to calculate total (more than 6 colomns)

Anonymous — Sat, 16 Nov 2024 02:28:50 GMT

Hi ,

I am trying to sum up sales value from multiple colomns from my input excel file , I have 12 colomns (sales per months ) and I have to sum up to get the annual sales ,so I have added tmap and set :
row1.Jan_sales+row1.Feb_sales+...+row1.Dec_sales <==> Annual_sales
but it fails as it doesnt recognized colmns after row1.June_sales .
Any idea how I can overcome this to calculate the annual sales from my input excel ?

Thanks in advance

Re: sum up values from input excel files from tmap to calculate total (more than 6 colomns)

TRF — Sun, 10 May 2020 06:59:01 GMT

You don't share enough.
What kind of error, compilation or runtime (with error message)?
What do the schema and code look like?

topic sum up values from input excel files from tmap to calculate total (more than 6 colomns) in Talend Studio

sum up values from input excel files from tmap to calculate total (more than 6 colomns)

Re: sum up values from input excel files from tmap to calculate total (more than 6 colomns)