Excel Crosstab / PivotTable to DB Table

Highlighted
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?
Highlighted
One Star

Re: Excel Crosstab / PivotTable to DB Table

I have the same issue.
Does someone have any idea?
Thanks
Highlighted
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
Highlighted
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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog