Excel Crosstab / PivotTable to DB Table

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

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now