tPivotToColumnsDelimited not writing into a file

[Anonymous]

Hi Talend Community,

The component tPivotToColumnsDelimited, in fact, is doing exactly what I want. I have a rows that i want to become columns. It's working very well.

But my problem is that it's writing in file and you can't select the sheet your writing in.

I would like to use several tPivotToColumnsDelimited in the same file to build several tables.

But when you use the component on the same file it just overwrite what you did before.

So, is there a way to maybe not write directly in a file and pass the flow through a main row ?

Or is there a way to choose to the sheet where you write to avoid overwriting what you did before and write in an other sheet ?

It's 2 working solutions but i don't know if it's possible to do it in Talend.

Thank you in advance  

[Anonymous]

Sorry, not able to understand

[Anonymous]

I can understand DGM ahah it's not easy to explain. 

To make it easier, i'll explain my project and what i'm doing maybe it will help :

My company is using a CRM software. I use the API of this software to get the datas that i'm interested in and i write them in an excel file.

I want to make those datas easier to read. So i treat it to construct tables like this one :

From columns D to N, it's the tPivotToColumnsDelimited who generate them.

But as you know this component only offer the possibility to write the datas in a file :

So my problem is that after writing my first table in a file with the component i need to build other tables using the same component.

I would like to write this tables all in the same file but in different sheet. But it's not possible to do it with a tPivotToColumnsDelimited, as i know.

So my question is :

Is there a way to do it with this component ? If no, is there another component who permit it ?

I hope it's more understandable !

Thank  you in advance.

[Anonymous · Accepted solution]

I suggest you first creat all your csv files

second step : you read each file and write in a sheet of xlsx file

I don't see any other solution

[Anonymous]

Thank you mate ! It's a working solution

Cya !