Dynamic pivotTable in fileOutputExcel resulting from data selection?

One Star

Dynamic pivotTable in fileOutputExcel resulting from data selection?

Hello,
I use a tFileOutputExcel component to collect data from a database for statistics purpose.
I need to declare a pivotTable selection to get a better view of selected data.
How can I do to get the benefit of a pre-configured pivotTable ("Tableau Croisé Dynamique") without needing to apply a new pivotTable anytime I need to refresh statistics results.
If I use a tFileCopy to retreive a kind of excelOutputFile template with preconfigured settings of a pivotTable in a sheet as output columns names are always fixed values, I got the selected data but the excelSheet containing the pivotTable is no longer active as a pivotTable but only contains fixed data.
How can I do to keep the dynamic pivotTable selection for further statistic purpose of a new data selection set?
Anyhelp would be appreciated.
Kind regards,
JNB
One Star

Re: Dynamic pivotTable in fileOutputExcel resulting from data selection?

Hi!
A possible solution not involving OpenStudio, but just excel:
Create the Pivot-Table in a seperate Excel file (call it pivot.xls), referencing the data from your output excel file (output.xls).
In theory, each time you open pivot.xls, Excel will ask you if you want to update the data from the external output.xml file. Even if excel does not ask you, you should be able to simply right-click on the pivot table and choose to update the data.
As long as output.xls is always stored to the same location this should work. When creating the pivot table you can choose to also "embed" the data, so that pivot.xls can be used on another system that does not have output.xls.
Hope that helps.
Regards from Vienna,
Richard Unger
One Star

Re: Dynamic pivotTable in fileOutputExcel resulting from data selection?

Hi,
thanks for your help, I think it could work. I'll let you know in a couple of days.
Bye.
JNB
One Star

Re: Dynamic pivotTable in fileOutputExcel resulting from data selection?

I have somehow the same problem:
I get bug csv files from an external application, and I would like to use Talend to create pivot Table. I can not use Excel since the file have too many lines.
Is there an easy way to do a pivot table in Talend Open Studio ?
Thanks in advance for your answer,