View Full Version : reports on "select values" step
04-26-2006, 11:50 PM
I would like to know how can i get a report on this step.
I need to show the input fields and the renaming in a report.
I don't want to open the spoon and print the screen each time, I want to create it from the ktr file.
04-27-2006, 08:04 AM
look at the tables R_STEPxxx in your repository. You could create a "reflection" for your steps.
04-27-2006, 09:58 PM
What if I'm not working with a repository?
04-28-2006, 02:05 AM
In that case, write a small java program that loads the transformation and print out the changes:
StepMeta stepMeta = transMeta.findStep("Some step name");
SelectValuesMeta meta = (SelectValuesMeta)stepMeta.getStepMetaInterface();
With this meta object you can see which fields are selected, renamed, removed, etc.
In the future we will build more meta-data management and lookup stuff into Kettle. For example transformation and job "reports" and search functionality.
Hope this helps,
06-26-2006, 01:04 PM
Or: Read in the KTR-file with the XML step.
Jens (from an ancient time zone - some months ago ;-)