tfileinputexcel extract table

Highlighted
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)
Sixteen Stars TRF
Sixteen Stars

Re: tfileinputexcel extract table

With a fixed number of days and products or not?


TRF
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 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 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