DetailFromDate

Generator

Distribution

Output

Scheduler

Misc.

Tags

DetailFromDate

Gets parts from a timestamp in another field (like year, quarter, ...) and format it according to the output format string. Additionally to the default specifier this generator supports the following strings wrapped in '' within the format string: [IS_HOLIDAY, IS_LAST_DAY_IN_WEEK, IS_LAST_DAY_IN_MONTH, IS_WEEK_DAY, IS_MARKET_HOUR, IS_OFFICE_HOUR, MONTH_SEQUENCE, WEEK_SEQUENCE, QUARTER_SEQUENCE, SECONDS_SEQUENCE, YEAR_OF_DATE, MONTH_OF_YEAR, WEEK_OF_YEAR, WEEK_OF_MONTH, QUATER_OF_YEAR, ExtendedFormat]. Example: <outputFormat>yyyy'QUATER_OF_YEAR'</outputFormat> will produce "20162" as result for the input date 2016-05-23

Attributes
Name Description Required Min Max Allowed Values
name (Class)Name of this element. Used to identify plugin Class. Full name is required. Example: com.en.myPluginPackage.myPuginClass no 0 1
id Identification String of this element. May be used to uniquely identify a field within the children of an Element. no 0 1
Nodes
Name Description Required Min Max Allowed Values
disableRng Content type: Boolean
If set to true, instead of choosing a random date within the date range, use the the current row id as position marker to traverse the date range from start to end.
Default: false		 no 0 1
  • true
  • false
  • 0
  • 1
endDate Content type: Date or property
End of time interval from which values are generated. Expecting either a human readable time format or properties. Default format: yyyy-MM-dd HH:mm:ss Examples: 2013-12-31 23:45:59 or ${someUserDefinedProperty}		 no 0 1
historicalEndDate Content type: Date or property
Sets a separate date range in case your historical range (range [0,1[ or in case 'historicalTimeIDsCount' is set [0,historicalTimeIDsCount[) differs from the normal range ([startDate, endDate]). The normal range will be used for the update parts of a table in that case.End of time interval from which values are generated. Expecting either a human readable time format or properties. Default format: yyyy-MM-dd HH:mm:ss Examples: 2013-12-31 23:45:59 or ${someUserDefinedProperty}		 no 0 1
startDate Content type: Date or property
Begin of time interval from which values are generated. Expecting either a human readable time format or properties. Default format: yyyy-MM-dd HH:mm:ss Examples: 2013-12-31 23:45:59 or ${someUserDefinedProperty}		 no 0 1
historicalStartDate Content type: Date or property
Sets a separate date range in case your historical range (range [0,1[ or in case 'historicalTimeIDsCount' is set [0,historicalTimeIDsCount[) differs from the normal range ([startDate, endDate]). The normal range will be used for the update parts of a table in that case.Begin of time interval from which values are generated. Expecting either a human readable time format or properties. Default format: yyyy-MM-dd HH:mm:ss Examples: 2013-12-31 23:45:59 or ${someUserDefinedProperty}		 no 0 1
inputFormat Content type: String
Date or time input format for 'startDate', 'endDate', 'historicalStartDate' and 'historicalEndDate'. Default format: yyyy-MM-dd HH:mm:ss. Format specification: http://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html		 no 0 1
outputFormat Content type: String
Date or time output format. Default format: yyyy-MM-dd HH:mm:ss. Format specification: http://docs.oracle.com/javase/8/docs/api/java/text/SimpleDateFormat.html . Additionally to the default specifier this generator supports the following strings wrapped in '' within the format string: [IS_HOLIDAY, IS_LAST_DAY_IN_WEEK, IS_LAST_DAY_IN_MONTH, IS_WEEK_DAY, IS_MARKET_HOUR, IS_OFFICE_HOUR, MONTH_SEQUENCE, WEEK_SEQUENCE, QUARTER_SEQUENCE, SECONDS_SEQUENCE, YEAR_OF_DATE, MONTH_OF_YEAR, WEEK_OF_YEAR, WEEK_OF_MONTH, QUATER_OF_YEAR, ExtendedFormat]. Example: <outputFormat>yyyy'QUATER_OF_YEAR'</outputFormat> will produce "20162" as result for the input date 2016-05-23		 no 0 1
historicalTimeIDsCount Content type: Integer
Number of timeID's treated logically as 'historical'. Logically, historical timeIDs can have a different date/time range than 'normal' timeID's. For historical timeIDs the date/time range: [historicalStartDate, historicalEndDate] is used
Default: 1		 no 0 1
reference reference. Possible references are: id="startDateRef", id="endDateRef", id="historicalStartDateRef", id="historicalEndDateRef no 0 1
useFixedStepSize Content type: Boolean
If set to false, each date_n will be computed with: date_n = date_n-1 + random. If set to true, each date will have a distance of [startDate, endDate] / numberOfRows to its next date.
Default: false		 no 0 1
  • true
  • false
  • 0
  • 1
isFiscal Content type: Boolean
If set to true, half a year is added to the chosen date.
Default: false		 no 0 1
  • true
  • false
  • 0
  • 1
gen Value Generator for this field no 0 1
2.7-83fb0 | 2020-04-22