PDA

View Full Version : reports on "select values" step



giyoram
04-26-2006, 11:50 PM
Hi,


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.



Thanks

jbleuel
04-27-2006, 08:04 AM
Hi,


look at the tables R_STEPxxx in your repository. You could create a "reflection" for your steps.



HTH,
Jens

kettle_anonymous
04-27-2006, 09:58 PM
What if I'm not working with a repository?

MattCasters
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,

Matt

jbleuel
06-26-2006, 01:04 PM
Or: Read in the KTR-file with the XML step.

Cheers,
Jens (from an ancient time zone - some months ago ;-)