how to iterate in tfileOutputExcel in column R and not in a column A without delete first lines?

[Anonymous]

ello

It's again me ! Sorry, i again learn use Talend since three months. 

So....I want put these two column in column P because Column A to N, there will be graphs in this location.

But the matter, there are a same line and the last name in column P whereas there is a complete column in A and B.

 

this is the job : It is a iteration because i only want ten first lines on 50. It is why there is a tJava (Numeric.sequence("iteration",0,1)

and a connexion If : Numeric.sequence("iteration",0,0)<10

And in tFileoutputExcel , i put : 

"Absolutely is a position Y : first cell X 16 ; first cell Y : Numeric.sequence("iteration",0,0) 

 

I don't unsterdand why it don't work....again.

Thanks in advance

[Anonymous]

No? Anyone? Who knows how to move all column with all names in column R on Excel after iteration?

Maybe  @manodwhb ? @rhall ?

[Anonymous]

it's impossible to resolve that? My colleague and me, we don't manage to resolve that. all components are correct but it don't work...

Please, i must resolve that... 

[Anonymous · Accepted solution]

Resolve.

With much efforts and ask everyone. 

The matter is : header was checked and it delete names except the last name.

Now I don't have a header anymore but never bind, now, i had all names in a good column. I will write the header directly in Excel.