One Star

Excel Crosstab / PivotTable to DB Table

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?
3 REPLIES
One Star

Re: Excel Crosstab / PivotTable to DB Table

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

Re: Excel Crosstab / PivotTable to DB Table

Hello
Please try the tUnpivot component on exchange
Best regards

shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Excel Crosstab / PivotTable to DB Table

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.