tfileinputexcel extract table

Six Stars

tfileinputexcel extract table

Hi,

 

Can anyone help to provide solution on how do I extract an excel table like in the first image and output them in the form of the second image? 

 

Excel table:

sample 2d.JPG

 

Desired output:

samaple 1d.JPG

 

Thank you!

Tags (3)
Highlighted
Sixteen Stars
Sixteen Stars

Re: tfileinputexcel extract table

With a fixed number of days and products or not?


TRF
Highlighted
Six Stars

Re: tfileinputexcel extract table


@TRF wrote:

With a fixed number of days and products or not?


Yes, fixed number of days and products

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

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog