tFileExcelWorkbookOpen & tFileExcelSheetOutput - can only iterate

One Star

tFileExcelWorkbookOpen & tFileExcelSheetOutput - can only iterate

Hello,

I want to use the tFileExcelSheetOutput component to format data in an Excel file
At each execution, I want to create a new Ecel file

So I want to have something like:






and currently I have the error:






why?

How to solve it?

thanks

Didier

One Star

Re: tFileExcelWorkbookOpen & tFileExcelSheetOutput - can only iterate

Is somebody able to explain me why and how to implement the tFileExcelWorrkbookOpen and the tFlowToIterate components?

Thanks

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog