Multiple Use Copy rows to result , Pentaho 9.3

[Dheerendra Chaurasiya]

Hello,

I need to use two table input query result source and target table and compare the result in different -2 transformations in a job.

I follow below steps:

1. Create the First Transformation:

   - Set up your first query using a Table Input step.

   - Use a "Copy row to result" step to store the result of the first query in a variable (let's call it `var_query1_result`).

2. Create the Second Transformation:

   - Create a new transformation for the second query's result.

   - Use a Table Input step to fetch the data for the second query.

   - Use a "Copy row to result" step to store the result of the second query in a different variable (let's call it `var_query2_result`).

3. Create the Third Transformation:

   - Create another new transformation for the final processing.

   - Use a "Get Variables" step to retrieve the values of `var_query1_result` and `var_query2_result`. 

But I am getting the error message "Set variables.0 - Only 1 input row was expected to set the variables and at least 2 were received."

Please help me to implement the requirement.

Thanks

[Juan Sierra Pons]

Hi,

Can you please provide a dummy .ktr that simulates yours?

Best regards

--------------------------------------------------------------------------------------
Juan Sierra Pons                                 ju...@elsotanillo.net
Linux User Registered: #257202      
Web: http://www.elsotanillo.net Git: http://www.github.com/juasiepo
Key Fingerprint = 0AD3F3DB8DE5183394882263FC429375EF21B13F
--------------------------------------------------------------------------------------

--
You received this message because you are subscribed to the Google Groups "Pentaho Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pentaho-commun...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pentaho-community/4331037a-808b-4b2b-b963-511f8c7c2648n%40googlegroups.com.