I a new to Pentaho and i am trying to put data into an excel sheet in any specific cell i need to. I currently have table input but the data is not exactly aligned with my output excel template (Excel Writer). How can i choose where Pentaho inserts my data into? I have tried to use multiple transformations to write into each column but i do not know if there is a better way.
In the attached image you see several columns. I need to insert a count query into each column titled "Count", "Completed", "Pending".
Thank you!
The trick with PDI (and all ETL tools ion general) is to produce the output as you want and, when this is done, you drop the result in the Excel file. That way you avoid to target each data value to a specific cell.
In you case you need to produce a 16 column flow, with column containing the date, the ABP Enrolement Count, the ABP Enrolement Completed, the ABP Enrolement Pending, the APB reject Count,... And write this result to the Excel Writer.
In order to achieve this flow, you'll probably need to denormalize and group your input, but it is difficult to answer not knowing the format of your input data.
