Hi everyone,
Forgive me as I am still learning Talend, and Java quite honestly.
I have a sales data source over time that is structured in a way that I don't particularly care for. Right now, the data is columnwise where the dates are across the top, I need them to be down the side. See below:
So, in an ideal world, I would be able to take the above and turn it into something like the table below, essentially summing the gross sales column, units column, and 9L cases column and attributing these totals to a month column:
Month | Gross Sales | Units | Cases
Jan | 10000 | 30 | 1000
Feb | 20000 | 60 | 2000
Mar | 15000 | 45 | 1500
I tried to work with a trowsplit, but I think I may be ahead of myself there.
Thank you all for any help.
Take care,
Micael
