topic Re: Excel Crosstab / PivotTable to DB Table in Talend Studio

Excel Crosstab / PivotTable to DB Table

Anonymous — Sat, 16 Nov 2024 14:25:46 GMT

Hello -
I have an Excel worksheet with a crosstab (PivotTable) with:
YYMM1 YYMM2 YYMM3
Mfg1 Product1 Prod1YYMM1Value Prod1YYMM2Value Prod1YYMM3Value, etc.
Mfg1 Product2 Prod2YYMM1Value Prod2YYMM2Value Prod2YYMM3Value ,etc.
Mfg2 Product3 Prod3YYMM1Value Prod3YYMM2Value Prod3YYMM3Value, etc.

I would like to move this to a table that has the schema (Mfg, Product, Year, Month, Value), so I have rows like:
MFG1 PRODUCT1 YYMM1 Prod1YYMM1Value
MFG1 PRODUCT2 YYMM1 Prod2YYMM1Value
MFG2 PRODUCT3 YYMM1Prod3YYMM1Value
etc.
Is there a component that can do this? I know how to go from the table to the cross tab, but is there an easy way to go back?

Re: Excel Crosstab / PivotTable to DB Table

Anonymous — Thu, 11 Jun 2009 16:19:04 GMT

I have the same issue.
Does someone have any idea?
Thanks

Re: Excel Crosstab / PivotTable to DB Table

Anonymous — Fri, 12 Jun 2009 04:41:48 GMT

Hello
Please try the tUnpivot component on exchange
Best regards

shong

Re: Excel Crosstab / PivotTable to DB Table

_AnonymousUser — Wed, 02 Mar 2016 16:30:25 GMT

Hello,
I would like to know if u find a solution for your problem. I mean is there any idea to read a pivot table through components of Talend.
Thanks in advance.