Gathering data to make data long rather than wide.

Anonymous — Wed, 03 Apr 2019 17:19:35 GMT

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

Re: Gathering data to make data long rather than wide.

fdenis — Wed, 03 Apr 2019 21:57:10 GMT

have a look at tnormalise and tdenormalise.
good luck

topic Gathering data to make data long rather than wide. in Talend Studio

Gathering data to make data long rather than wide.

Re: Gathering data to make data long rather than wide.