topic tPivotToColumnsDelimited not writing into a file in Talend Studio

tPivotToColumnsDelimited not writing into a file

Anonymous — Fri, 31 May 2019 10:25:01 GMT

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

Re: tPivotToColumnsDelimited not writing into a file

Anonymous — Fri, 31 May 2019 13:20:16 GMT

Sorry, not able to understand

Re: tPivotToColumnsDelimited not writing into a file

Anonymous — Fri, 31 May 2019 13:37:55 GMT

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.

Re: tPivotToColumnsDelimited not writing into a file

Anonymous — Fri, 31 May 2019 17:05:07 GMT

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

Re: tPivotToColumnsDelimited not writing into a file

Anonymous — Mon, 03 Jun 2019 08:46:43 GMT

Thank you mate ! It's a working solution

Cya !