Pivoting to columns and read data without using tFileDelimited
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).
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.
