Hitachi Vantara Pentaho Community Wiki
Child pages
  • Excel Input Step
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 8 Current »

Description

Collection of Excel Input Step tips, tricks, comments, gotchas, and capabilities.

Useful forum threads as of 2/15/2008

Number to Date Conversion

(example: 20051028 > October 28th, 2005) you should simply specify the conversion mask yyyyMMdd because there will be an implicit Number to String conversion taking place before doing the String to Date conversion.  source: Spoon 3.0 user manual

Metadata Injection Support

You can use the Metadata Injection supported fields with ETL Metadata Injection step to pass metadata to your transformation at runtime. The following Option and Value fields of the Microsoft Excel Input step support metadata injection:

  • Options: File and Directory, Regular Expression, Exclude Regular Expression, Selected Files, Accept Filenames from Previous Steps, and Show Filenames
  • Values: Name, Type, Length, Precision, Trim Type, Format, Currency, Decimal, and Grouping
  • No labels