Pivoting to columns and read data without using tFileDelimited

Remoz-83 — Fri, 15 Nov 2024 22:50:03 GMT

Dears,

as per the attached printscreen, I created a job that is reading data from a SQL table pivoting rows to columns using tPivotToColumnsDelimited.

It produces a .CSV file that I need to read immediately after using a tFileDelimited and mapping the rows with tMap to a tHashOutput destination.

It works fine, but sometimes It fails producing the error "java.io.FileNotFoundException:C:\***\***\filename.csv (Access denied)"

I wonder to know if it is possible to obtain the same (I mean pivoting rows to columns from a table source to map an output table) without creating a csv and reading it immediately after or any suggestion to improve my jobs and avoid the problem (I have already checked permissions, it works normally but sometimes it gives this error).

Thanks and best regards,

Re: Pivoting to columns and read data without using tFileDelimited

Antonio69 — Wed, 15 Jun 2022 06:31:07 GMT

After creating a PivotTable and adding the fields that you want to analyze, you may want to enhance the report layout and format to make the data easier to read and scan for details. To change the layout of a PivotTable, you can change the PivotTable form and the way that fields, columns, rows, subtotals, empty cells and lines are displayed. To change the format of the PivotTable, you can apply a predefined style, banded rows, and conditional formatting.

topic Re: Pivoting to columns and read data without using tFileDelimited in Talend Studio

Pivoting to columns and read data without using tFileDelimited

Re: Pivoting to columns and read data without using tFileDelimited