Good night, I make a query in relation to pentaho, spoon. I have a transformation that has an 'Input to Table' step where I add an alias to a table field. eg select id as dim_pais_id from dim_paises The transformation runs correctly in spoon V9.0. Then, when going to production, on the Pentaho server, when executing the transformation, an error is generated since when performing the insert it says that dim_pais_id cannot find the dim_pais_id field. Verify in the 'Entry to Table' step that the select is made, when executing preview it is not recognizing aliases, the field is displayed as id instead of dim_pais_id(alias). (Pentaho Server Version 8). Is there a variable that I need to parameterize for the field alias to work? Could you help me to solve the error? Thank you so much Andrea
Good night,
I make a query in relation to pentaho, spoon.
I have a transformation that has an 'Input to Table' step where I add an alias to a table field.
eg select id as dim_pais_id from dim_paises
The transformation runs correctly in spoon V9.0.
Then, when going to production, on the Pentaho server, when executing the transformation, an error is generated since when performing the insert it says that dim_pais_id cannot find the dim_pais_id field.
Verify in the 'Entry to Table' step that the select is made, when executing preview it is not recognizing aliases, the field is displayed as id instead of dim_pais_id(alias). (Pentaho Server Version 8).
Is there a variable that I need to parameterize for the field alias to work? Could you help me to solve the error?
Thank you so much
Andrea