|D s product|
NOTE: Locale settings apply only to the inference and validation of data in the
NOTE: After saving changes to your locale, refresh your page. Subsequent executions of the data inference service use the new locale settings.
NOTE: When locale is changed, data type validation is affected only on subsequent executions of the data type inference service. If you are using structured datasets, such as schematized JDBC sources, data types may be attached to the datasets that you have already imported. These data types are not affected.
|System||The default locale for the system is |
|Workspace||For all members of the workspace, administrators can be configure the locale setting. See Workspace Settings Page.|
Individual users can choose their own locale settings. For more information, see User Profile Page.
The following locales are available:
Product Areas Affected by Locale
- Data type inference more accurately recognizes Datetime values based on locale settings.
- Suggestion cards containing Datetime transformations and example previews utilize locale settings.
Number of weeks in the year may vary. For example, the WEEKNUM function calculated on the last few dates of the calendar year may return different values depending on the locale where the calculation is performed:
NOTE: The output calculations for number of weeks may vary between browser,
, and the running environment where the job may be executed, based upon locale.
D s photon
EN-US: Maximum of 52 weeks
- ISO 8601: Maximum of 53 weeks
You can add steps similar to the following, which adds a 53rd week as a possible output for WEEKNUM:
D lang syntax RawWrangle true Type syntax showNote true WrangleText derive type: single value: dateformat(date(year(myDate), 1, 1), 'yyyy\/MM\/dd') as: 'NewYearsDayforMyYear'
derive type: single value: dateformat(date(year(myDate), 1, 1), 'yyyy\/MM\/dd') as: 'NewYearsDayforMyYear'
D lang syntax RawWrangle true Type syntax showNote true WrangleText derive type: single value: if(datedif(NewYearsDayforMyYear, myDate, day) > (52 * 7), 53, weeknum(myDate)) as: 'weekNumforMyDate'
derive type: single value: if(datedif(NewYearsDayforMyYear, myDate, day) > (52 * 7), 53, weeknum(myDate)) as: 'weekNumforMyDate'
- For more information, see WEEKNUM Function.