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

[Anonymous]

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

[TRF · Accepted solution]

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