Class FieldSplitterMeta
- java.lang.Object
-
- org.pentaho.di.trans.step.BaseStepMeta
-
- org.pentaho.di.trans.steps.fieldsplitter.FieldSplitterMeta
-
- All Implemented Interfaces:
Cloneable
,StepAttributesInterface
,StepMetaInterface
public class FieldSplitterMeta extends BaseStepMeta implements StepMetaInterface
Example1:
-------------
DATUM;VALUES
20031031;500,300,200,100
||
delimiter = , \||/
field[] = SALES1, SALES2, SALES3, SALES4 \/
id[] = idrem[] = no, no, no, no type[] = Number, Number, Number, Number format[] = ###.##, ###.##, ###.##, ###.## group[] = decimal[] = . currency[] = length[] = 3, 3, 3, 3 precision[] = 0, 0, 0, 0 DATUM;SALES1;SALES2;SALES3;SALES4
20031031;500;300;200;100
Example2:
-----------
20031031;Sales2=310.50, Sales4=150.23
|| delimiter = ,
\||/ field[] = SALES1, SALES2, SALES3, SALES4
\/ id[] = Sales1, Sales2, Sales3, Sales4
idrem[] = yes, yes, yes, yes (remove ID's from split field)
type[] = Number, Number, Number, Number
format[] = ###.##, ###.##, ###.##, ###.##
group[] =
decimal[] = .
currency[] =
length[] = 3, 3, 3, 3
precision[] = 0, 0, 0, 0
DATUM;SALES1;SALES2;SALES3;SALES4
20031031;310,50;150,23
-
-
Field Summary
-
Fields inherited from class org.pentaho.di.trans.step.BaseStepMeta
attributes, databases, log, loggingObject, parentStepMeta, repository, STEP_ATTRIBUTES_FILE
-
-
Constructor Summary
Constructors Constructor Description FieldSplitterMeta()
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
afterInjectionSynchronization()
If we use injection we can have different arrays lengths.void
allocate(int nrfields)
void
check(List<org.pentaho.di.core.CheckResultInterface> remarks, TransMeta transMeta, StepMeta stepMeta, org.pentaho.di.core.row.RowMetaInterface prev, String[] input, String[] output, org.pentaho.di.core.row.RowMetaInterface info, org.pentaho.di.core.variables.VariableSpace space, Repository repository, org.pentaho.metastore.api.IMetaStore metaStore)
Checks the settings of this step and puts the findings in a remarks List.Object
clone()
Make an exact copy of this step, make sure to explicitly copy Collections etc.String
getDelimiter()
String
getEnclosure()
String[]
getFieldCurrency()
String[]
getFieldDecimal()
String[]
getFieldFormat()
String[]
getFieldGroup()
String[]
getFieldID()
String[]
getFieldIfNull()
int[]
getFieldLength()
String[]
getFieldName()
String[]
getFieldNullIf()
int[]
getFieldPrecision()
boolean[]
getFieldRemoveID()
void
getFields(org.pentaho.di.core.row.RowMetaInterface r, String name, org.pentaho.di.core.row.RowMetaInterface[] info, StepMeta nextStep, org.pentaho.di.core.variables.VariableSpace space, Repository repository, org.pentaho.metastore.api.IMetaStore metaStore)
Gets the fields.int
getFieldsCount()
int[]
getFieldTrimType()
int[]
getFieldType()
String
getSplitField()
StepInterface
getStep(StepMeta stepMeta, StepDataInterface stepDataInterface, int cnr, TransMeta transMeta, Trans trans)
Get the executing step, needed by Trans to launch a step.StepDataInterface
getStepData()
Get a new instance of the appropriate data class.String
getXML()
Produces the XML string that describes this step's information.void
loadXML(Node stepnode, List<org.pentaho.di.core.database.DatabaseMeta> databases, org.pentaho.metastore.api.IMetaStore metaStore)
Load the values for this step from an XML Nodevoid
readRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_step, List<org.pentaho.di.core.database.DatabaseMeta> databases)
Read the steps information from a Kettle repositoryvoid
saveRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_transformation, org.pentaho.di.repository.ObjectId id_step)
Save the steps data into a Kettle repositoryvoid
setDefault()
Set default valuesvoid
setDelimiter(String delimiter)
void
setEnclosure(String enclosure)
void
setFieldCurrency(String[] fieldCurrency)
void
setFieldDecimal(String[] fieldDecimal)
void
setFieldFormat(String[] fieldFormat)
void
setFieldGroup(String[] fieldGroup)
void
setFieldID(String[] fieldID)
void
setFieldIfNull(String[] fieldIfNull)
void
setFieldLength(int[] fieldLength)
void
setFieldName(String[] fieldName)
void
setFieldNullIf(String[] fieldNullIf)
void
setFieldPrecision(int[] fieldPrecision)
void
setFieldRemoveID(boolean[] fieldRemoveID)
void
setFieldTrimType(int[] fieldTrimType)
void
setFieldType(int[] fieldType)
void
setSplitField(String splitField)
-
Methods inherited from class org.pentaho.di.trans.step.BaseStepMeta
analyseImpact, analyseImpact, cancelQueries, check, check, createEntry, excludeFromCopyDistributeVerification, excludeFromRowLayoutVerification, exportResources, exportResources, extractStepMetadataEntries, findAttribute, findParent, findParentEntry, getActiveReferencedObjectDescription, getDescription, getDialogClassName, getFields, getLog, getLogChannelId, getName, getObjectCopy, getObjectId, getObjectRevision, getObjectType, getOptionalStreams, getParent, getParentStepMeta, getReferencedObjectDescriptions, getRepCode, getRepositoryDirectory, getRequiredFields, getRequiredFields, getResourceDependencies, getSQLStatements, getSQLStatements, getStepInjectionMetadataEntries, getStepIOMeta, getStepIOMeta, getStepMetaInjectionInterface, getSupportedTransformationTypes, getTableFields, getTooltip, getUsedArguments, getUsedDatabaseConnections, getUsedLibraries, getXmlCode, handleStreamSelection, hasChanged, hasRepositoryReferences, isBasic, isDebug, isDetailed, isReferencedObjectEnabled, isRowLevel, loadReferencedObject, loadReferencedObject, loadStepAttributes, loadXML, loadXML, logBasic, logBasic, logDebug, logDebug, logDetailed, logDetailed, logError, logError, logError, logMinimal, logMinimal, logRowlevel, logRowlevel, lookupRepositoryReferences, readRep, readRep, resetStepIoMeta, saveRep, searchInfoAndTargetSteps, setChanged, setChanged, setParentStepMeta, setStepIOMeta, supportsErrorHandling
-
Methods inherited from class java.lang.Object
equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
-
Methods inherited from interface org.pentaho.di.trans.step.StepMetaInterface
analyseImpact, analyseImpact, cancelQueries, check, cleanAfterHopFromRemove, cleanAfterHopFromRemove, cleanAfterHopToRemove, excludeFromCopyDistributeVerification, excludeFromRowLayoutVerification, exportResources, exportResources, extractStepMetadataEntries, fetchTransMeta, getActiveReferencedObjectDescription, getDialogClassName, getFields, getOptionalStreams, getParentStepMeta, getReferencedObjectDescriptions, getRequiredFields, getResourceDependencies, getSQLStatements, getSQLStatements, getStepIOMeta, getStepMetaInjectionInterface, getSupportedTransformationTypes, getTableFields, getUsedArguments, getUsedDatabaseConnections, getUsedLibraries, handleStreamSelection, hasChanged, hasRepositoryReferences, isReferencedObjectEnabled, loadReferencedObject, loadXML, lookupRepositoryReferences, passDataToServletOutput, readRep, resetStepIoMeta, saveRep, searchInfoAndTargetSteps, setChanged, setParentStepMeta, supportsErrorHandling
-
-
-
-
Method Detail
-
getSplitField
public String getSplitField()
-
setSplitField
public void setSplitField(String splitField)
-
getDelimiter
public String getDelimiter()
-
setDelimiter
public void setDelimiter(String delimiter)
-
getEnclosure
public String getEnclosure()
-
setEnclosure
public void setEnclosure(String enclosure)
-
getFieldName
public String[] getFieldName()
-
setFieldName
public void setFieldName(String[] fieldName)
-
getFieldID
public String[] getFieldID()
-
setFieldID
public void setFieldID(String[] fieldID)
-
getFieldRemoveID
public boolean[] getFieldRemoveID()
-
setFieldRemoveID
public void setFieldRemoveID(boolean[] fieldRemoveID)
-
getFieldType
public int[] getFieldType()
-
setFieldType
public void setFieldType(int[] fieldType)
-
getFieldFormat
public String[] getFieldFormat()
-
setFieldFormat
public void setFieldFormat(String[] fieldFormat)
-
getFieldGroup
public String[] getFieldGroup()
-
setFieldGroup
public void setFieldGroup(String[] fieldGroup)
-
getFieldDecimal
public String[] getFieldDecimal()
-
setFieldDecimal
public void setFieldDecimal(String[] fieldDecimal)
-
getFieldCurrency
public String[] getFieldCurrency()
-
setFieldCurrency
public void setFieldCurrency(String[] fieldCurrency)
-
getFieldLength
public int[] getFieldLength()
-
setFieldLength
public void setFieldLength(int[] fieldLength)
-
getFieldPrecision
public int[] getFieldPrecision()
-
setFieldPrecision
public void setFieldPrecision(int[] fieldPrecision)
-
getFieldNullIf
public String[] getFieldNullIf()
-
setFieldNullIf
public void setFieldNullIf(String[] fieldNullIf)
-
getFieldIfNull
public String[] getFieldIfNull()
-
setFieldIfNull
public void setFieldIfNull(String[] fieldIfNull)
-
getFieldTrimType
public int[] getFieldTrimType()
-
setFieldTrimType
public void setFieldTrimType(int[] fieldTrimType)
-
loadXML
public void loadXML(Node stepnode, List<org.pentaho.di.core.database.DatabaseMeta> databases, org.pentaho.metastore.api.IMetaStore metaStore) throws org.pentaho.di.core.exception.KettleXMLException
Description copied from interface:StepMetaInterface
Load the values for this step from an XML Node- Specified by:
loadXML
in interfaceStepMetaInterface
- Overrides:
loadXML
in classBaseStepMeta
- Parameters:
stepnode
- the Node to get the info fromdatabases
- The available list of databases to reference tometaStore
- the metastore to optionally load external reference metadata from- Throws:
org.pentaho.di.core.exception.KettleXMLException
- When an unexpected XML error occurred. (malformed etc.)
-
allocate
public void allocate(int nrfields)
-
clone
public Object clone()
Description copied from interface:StepMetaInterface
Make an exact copy of this step, make sure to explicitly copy Collections etc.- Specified by:
clone
in interfaceStepMetaInterface
- Overrides:
clone
in classBaseStepMeta
- Returns:
- an exact copy of this step
-
setDefault
public void setDefault()
Description copied from interface:StepMetaInterface
Set default values- Specified by:
setDefault
in interfaceStepMetaInterface
-
getFieldsCount
public int getFieldsCount()
-
getFields
public void getFields(org.pentaho.di.core.row.RowMetaInterface r, String name, org.pentaho.di.core.row.RowMetaInterface[] info, StepMeta nextStep, org.pentaho.di.core.variables.VariableSpace space, Repository repository, org.pentaho.metastore.api.IMetaStore metaStore) throws org.pentaho.di.core.exception.KettleStepException
Description copied from class:BaseStepMeta
Gets the fields.- Specified by:
getFields
in interfaceStepMetaInterface
- Overrides:
getFields
in classBaseStepMeta
- Parameters:
r
- the input row meta that is modified in this method to reflect the output row metadata of the stepname
- Name of the step to use as input for the origin field in the valuesinfo
- Fields used as extra lookup informationnextStep
- the next step that is targetedspace
- the space The variable space to use to replace variablesrepository
- the repository to use to load Kettle metadata objects impacting the output fieldsmetaStore
- the MetaStore to use to load additional external data or metadata impacting the output fields- Throws:
org.pentaho.di.core.exception.KettleStepException
- the kettle step exception
-
getXML
public String getXML()
Description copied from class:BaseStepMeta
Produces the XML string that describes this step's information.- Specified by:
getXML
in interfaceStepMetaInterface
- Overrides:
getXML
in classBaseStepMeta
- Returns:
- String containing the XML describing this step.
-
readRep
public void readRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_step, List<org.pentaho.di.core.database.DatabaseMeta> databases) throws org.pentaho.di.core.exception.KettleException
Description copied from interface:StepMetaInterface
Read the steps information from a Kettle repository- Specified by:
readRep
in interfaceStepMetaInterface
- Overrides:
readRep
in classBaseStepMeta
- Parameters:
rep
- The repository to read frommetaStore
- The MetaStore to read external information fromid_step
- The step IDdatabases
- The databases to reference- Throws:
org.pentaho.di.core.exception.KettleException
- When an unexpected error occurred (database, network, etc)
-
saveRep
public void saveRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, org.pentaho.di.repository.ObjectId id_transformation, org.pentaho.di.repository.ObjectId id_step) throws org.pentaho.di.core.exception.KettleException
Description copied from interface:StepMetaInterface
Save the steps data into a Kettle repository- Specified by:
saveRep
in interfaceStepMetaInterface
- Overrides:
saveRep
in classBaseStepMeta
- Parameters:
rep
- The Kettle repository to save tometaStore
- the metaStore to optionally write toid_transformation
- The transformation IDid_step
- The step ID- Throws:
org.pentaho.di.core.exception.KettleException
- When an unexpected error occurred (database, network, etc)
-
check
public void check(List<org.pentaho.di.core.CheckResultInterface> remarks, TransMeta transMeta, StepMeta stepMeta, org.pentaho.di.core.row.RowMetaInterface prev, String[] input, String[] output, org.pentaho.di.core.row.RowMetaInterface info, org.pentaho.di.core.variables.VariableSpace space, Repository repository, org.pentaho.metastore.api.IMetaStore metaStore)
Description copied from interface:StepMetaInterface
Checks the settings of this step and puts the findings in a remarks List.- Specified by:
check
in interfaceStepMetaInterface
- Overrides:
check
in classBaseStepMeta
- Parameters:
remarks
- The list to put the remarks in @see org.pentaho.di.core.CheckResultstepMeta
- The stepMeta to help checkingprev
- The fields coming from the previous stepinput
- The input step namesoutput
- The output step namesinfo
- The fields that are used as information by the stepspace
- the variable space to resolve variable expressions withrepository
- the repository to use to load Kettle metadata objects impacting the output fieldsmetaStore
- the MetaStore to use to load additional external data or metadata impacting the output fields
-
getStep
public StepInterface getStep(StepMeta stepMeta, StepDataInterface stepDataInterface, int cnr, TransMeta transMeta, Trans trans)
Description copied from interface:StepMetaInterface
Get the executing step, needed by Trans to launch a step.- Specified by:
getStep
in interfaceStepMetaInterface
- Parameters:
stepMeta
- The step infostepDataInterface
- the step data interface linked to this step. Here the step can store temporary data, database connections, etc.cnr
- The copy nr to gettransMeta
- The transformation infotrans
- The launching transformation
-
getStepData
public StepDataInterface getStepData()
Description copied from interface:StepMetaInterface
Get a new instance of the appropriate data class. This data class implements the StepDataInterface. It basically contains the persisting data that needs to live on, even if a worker thread is terminated.- Specified by:
getStepData
in interfaceStepMetaInterface
- Returns:
- The appropriate StepDataInterface class.
-
afterInjectionSynchronization
public void afterInjectionSynchronization()
If we use injection we can have different arrays lengths. We need synchronize them for consistency behavior with UI
-
-