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?
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.
