Trifacta Wrangler (free)
Page tree


Support | Blog | Contact Us 

Trifacta Wrangler (free)


Contents:

NOTE:  Trifacta Wrangler is a free product with limitations on its features. Some features in the documentation do not apply to this product edition. See Product Limitations.

   

Trifacta® Wrangler supports a tier-based scheme for applying locale settings. 


NOTE: Locale settings apply only to the inference and validation of data in the Trifacta application. Underlying data is not affected by changing locale.

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.

Locale settings can be configured for:

  • Project or workspace level: global local for all users in the environment
  • User level: In User Preferences, individual users can set their personal locale.

Supported Locales

The following locales are available:

  • United States

  • Australia

  • Austria

  • Belgium

  • Bulgaria

  • Canada

  • Croatia

  • Cyprus

  • Czech Republic

  • Denmark

  • Estonia

  • Finland

  • France

  • Germany

  • Hungary

  • Greece

  • Ireland

  • Italy

  • Japan

  • Latvia

  • Lithuania

  • Luxembourg

  • Malta

  • New Zealand

  • Netherlands

  • Poland

  • Portugal

  • Romania

  • Singapore

  • Slovakia

  • Slovenia

  • Spain

  • Sweden

  • United Kingdom

Product Areas Affected by Locale

Datetime

  • 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, Trifacta Photon, and the running environment where the job may be executed, based upon locale.

    • 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:

      derive type: single value: dateformat(date(year(myDate), 1, 1), 'yyyy\/MM\/dd') as: 'NewYearsDayforMyYear'


      derive type: single value: if(datedif(NewYearsDayforMyYear, myDate, day) > (52 * 7), 53, weeknum(myDate)) as: 'weekNumforMyDate'

See Also for Locale Settings:

Send Feedback

This page has no comments.

© 2013-2022 Alteryx® Inc. Privacy Policy  |  Terms of Use