Pentaho

Just adding a comment to up the question in the queue of updates, in case someone who could help me was out on Easter holidays and didn't see it.

Regards

Ana, apologies for my delay. I hope this answer works for you.

Note, the Update step is seeking a stream of data for the following:

• values to compare against key table field
• values to update if result is true

Therefore, one does not provide the values above via MDI. One provides the name of the fields that hold these values within the connected stream.

I am including a zip containing 3 KTRs & 1 SQL.

• TR_TEST_DMW_Injector.ktr – injector KTR to prepare the 3 sets of injected metadata
• TR_TEST_DMW_Template.ktr – template transformation
• TR_TEST_DMW_Template_Functional.ktr – the same template transformation but completed and functional
• my_dummy_table.sql – sql to create and populate the dummy table

The tricky part is the Data Grid. Note, the data portion of the Data Grid step must be injected with a single vector of values equal in number to the n-rows x n-columns required. Further, one needs to provide the Data Grid step a listing of the fields in the Meta tab so that the injection knows the number of columns. Otherwise, you get an overflow error.

Thanks a lot, Derek, I'm going to test it and learn how it works.

Regards

Thanks a lot Derek, I did a quick check and it works, now I have to finish my current task so I have time to play with it and adapt it to my use case.

One question though, you use a step to create a hash with the updates cases that I haven't seen you use later in the transformation. In this simple example the hash is unique, but I'm my real case is going to have different values. Will I need to use it later to inject the metadata?

Regards