Constructor and Description |
---|
CalculatorMetaFunction() |
CalculatorMetaFunction(Node calcnode) |
CalculatorMetaFunction(Repository rep,
ObjectId id_step,
int nr) |
CalculatorMetaFunction(String fieldName,
int calcType,
String fieldA,
String fieldB,
String fieldC,
int valueType,
int valueLength,
int valuePrecision,
boolean removedFromResult,
String conversionMask,
String decimalSymbol,
String groupingSymbol,
String currencySymbol) |
public static final String XML_TAG
public static final int CALC_NONE
public static final int CALC_CONSTANT
public static final int CALC_COPY_OF_FIELD
public static final int CALC_ADD
public static final int CALC_SUBTRACT
public static final int CALC_MULTIPLY
public static final int CALC_DIVIDE
public static final int CALC_SQUARE
public static final int CALC_SQUARE_ROOT
public static final int CALC_PERCENT_1
public static final int CALC_PERCENT_2
public static final int CALC_PERCENT_3
public static final int CALC_COMBINATION_1
public static final int CALC_COMBINATION_2
public static final int CALC_ROUND_1
public static final int CALC_ROUND_2
public static final int CALC_ROUND_STD_1
public static final int CALC_ROUND_STD_2
public static final int CALC_CEIL
public static final int CALC_FLOOR
public static final int CALC_NVL
public static final int CALC_ADD_DAYS
public static final int CALC_YEAR_OF_DATE
public static final int CALC_MONTH_OF_DATE
public static final int CALC_DAY_OF_YEAR
public static final int CALC_DAY_OF_MONTH
public static final int CALC_DAY_OF_WEEK
public static final int CALC_WEEK_OF_YEAR
public static final int CALC_WEEK_OF_YEAR_ISO8601
public static final int CALC_YEAR_OF_DATE_ISO8601
public static final int CALC_BYTE_TO_HEX_ENCODE
public static final int CALC_HEX_TO_BYTE_DECODE
public static final int CALC_CHAR_TO_HEX_ENCODE
public static final int CALC_HEX_TO_CHAR_DECODE
public static final int CALC_CRC32
public static final int CALC_ADLER32
public static final int CALC_MD5
public static final int CALC_SHA1
public static final int CALC_LEVENSHTEIN_DISTANCE
public static final int CALC_METAPHONE
public static final int CALC_DOUBLE_METAPHONE
public static final int CALC_ABS
public static final int CALC_REMOVE_TIME_FROM_DATE
public static final int CALC_DATE_DIFF
public static final int CALC_ADD3
public static final int CALC_INITCAP
public static final int CALC_UPPER_CASE
public static final int CALC_LOWER_CASE
public static final int CALC_MASK_XML
public static final int CALC_USE_CDATA
public static final int CALC_REMOVE_CR
public static final int CALC_REMOVE_LF
public static final int CALC_REMOVE_CRLF
public static final int CALC_REMOVE_TAB
public static final int CALC_GET_ONLY_DIGITS
public static final int CALC_REMOVE_DIGITS
public static final int CALC_STRING_LEN
public static final int CALC_LOAD_FILE_CONTENT_BINARY
public static final int CALC_ADD_TIME_TO_DATE
public static final int CALC_QUARTER_OF_DATE
public static final int CALC_SUBSTITUTE_VARIABLE
public static final int CALC_UNESCAPE_XML
public static final int CALC_ESCAPE_HTML
public static final int CALC_UNESCAPE_HTML
public static final int CALC_ESCAPE_SQL
public static final int CALC_DATE_WORKING_DIFF
public static final int CALC_ADD_MONTHS
public static final int CALC_CHECK_XML_FILE_WELL_FORMED
public static final int CALC_CHECK_XML_WELL_FORMED
public static final int CALC_GET_FILE_ENCODING
public static final int CALC_DAMERAU_LEVENSHTEIN
public static final int CALC_NEEDLEMAN_WUNSH
public static final int CALC_JARO
public static final int CALC_JARO_WINKLER
public static final int CALC_SOUNDEX
public static final int CALC_REFINED_SOUNDEX
public static final int CALC_ADD_HOURS
public static final int CALC_ADD_MINUTES
public static final int CALC_DATE_DIFF_MSEC
public static final int CALC_DATE_DIFF_SEC
public static final int CALC_DATE_DIFF_MN
public static final int CALC_DATE_DIFF_HR
public static final int CALC_HOUR_OF_DAY
public static final int CALC_MINUTE_OF_HOUR
public static final int CALC_SECOND_OF_MINUTE
public static final int CALC_ROUND_CUSTOM_1
public static final int CALC_ROUND_CUSTOM_2
public static final int CALC_ADD_SECONDS
public static final int CALC_REMAINDER
public static final String[] calc_desc
public static final String[] calcLongDesc
public static final int[] calcDefaultResultType
public CalculatorMetaFunction(String fieldName, int calcType, String fieldA, String fieldB, String fieldC, int valueType, int valueLength, int valuePrecision, boolean removedFromResult, String conversionMask, String decimalSymbol, String groupingSymbol, String currencySymbol)
fieldName
- out field namecalcType
- calculation type, see CALC_* set of constants definedfieldA
- name of field "A"fieldB
- name of field "B"fieldC
- name of field "C"valueType
- out value typevalueLength
- out value lengthvaluePrecision
- out value precisionconversionMask
- out value conversion maskdecimalSymbol
- out value decimal symbolgroupingSymbol
- out value grouping symbolcurrencySymbol
- out value currency symbolpublic CalculatorMetaFunction()
public CalculatorMetaFunction(Node calcnode)
public CalculatorMetaFunction(Repository rep, ObjectId id_step, int nr) throws KettleException
KettleException
public String getXML()
public void saveRep(Repository rep, org.pentaho.metastore.api.IMetaStore metaStore, ObjectId id_transformation, ObjectId id_step, int nr) throws KettleException
KettleException
public static int getCalcFunctionType(String desc)
public static String getCalcFunctionDesc(int type)
public static String getCalcFunctionLongDesc(int type)
public static int getCalcFunctionDefaultResultType(int type)
public int getCalcType()
public void setCalcType(int calcType)
calcType
- The calcType to set.public String getCalcTypeDesc()
public String getCalcTypeLongDesc()
public String getFieldA()
public void setFieldA(String fieldA)
fieldA
- The fieldA to set.public String getFieldB()
public void setFieldB(String fieldB)
fieldB
- The fieldB to set.public String getFieldC()
public void setFieldC(String fieldC)
fieldC
- The fieldC to set.public String getFieldName()
public void setFieldName(String fieldName)
fieldName
- The fieldName to set.public int getValueLength()
public void setValueLength(int valueLength)
valueLength
- The valueLength to set.public int getValuePrecision()
public void setValuePrecision(int valuePrecision)
valuePrecision
- The valuePrecision to set.public int getValueType()
public void setValueType(int valueType)
valueType
- The valueType to set.public boolean isRemovedFromResult()
public void setRemovedFromResult(boolean removedFromResult)
removedFromResult
- The removedFromResult to set.public String getConversionMask()
public void setConversionMask(String conversionMask)
conversionMask
- the conversionMask to setpublic String getDecimalSymbol()
public void setDecimalSymbol(String decimalSymbol)
decimalSymbol
- the decimalSymbol to setpublic String getGroupingSymbol()
public void setGroupingSymbol(String groupingSymbol)
groupingSymbol
- the groupingSymbol to setpublic String getCurrencySymbol()
public void setCurrencySymbol(String currencySymbol)
currencySymbol
- the currencySymbol to setCopyright © 2018 Hitachi Vantara. All rights reserved.