What I have observed is that Pentaho tries to execute next after Block steps before Excel file is closed properly by the previous step. Looks like Block step can be an option, but somehow it doesn't work as expected with Excel Output / Writers node (or I do something wrong). If above doesn't work: Is it possible to embed transformations to the job instead of referencing them from external files?Īnd extra question: What is better to use: Excel Output or Excel Writer?īased on #AlainD proposal I have tried to put Block node in-between.
PENTAHO DATA INTEGRATION CSV FILE TO XML WITH XSD UPDATE
Is it possible to join 2 sequences from above sample with some wait node before starting update 2nd Excel sheet? I need to have at the end just one file with either Job or Transformation without dependencies (In case of above proposed scenario I would have 1 KJB job + 2 KTR transformation files). When I try to chain above sequences I loose content of first updated Excel sheet in the final document My understanding is that normal way to achieve it is to put first sequence in one transformation file with XML Output or Writer, second to the second one & at the end create job with chain from start, through 1st & 2nd transformations. I need to do the same and update two different sheets of the same MS Excel Documents. It reads separately from same XML input parent rows & children rows. Update multiple Excel sheets of one document within one Pentaho Kettle transformation I am researching standard sample from Pentaho DI package: GetXMLData - Read parent children rows.
0 kommentar(er)
