Does Aperture have the "treat leading zeros as alphanumeric" option that Pandora had

Charles Thomas
edited December 2023 in General

One a a global setting that instructed Pandora to treat any input field with leading zeros as alphanumeric so that the leading zeros were preserved. While I can see that one can set a field which has can have leading zeros as alphanumeric, this seems to require an analysis of the data to know that it has leading zeros - one knows about bank sort codes, bank account numbers, telephone numbers but there are often others lurking and an the global function was most useful.

Best Answer

  • Akshay Davis
    Akshay Davis Experian Super Contributor
    Answer ✓

    There is no global setting for treating any column of data with a leading 0 as alphanumeric, you can set a file loaded to treat every column as alphanumeric on load. This avoids losing leading zeros if they're significant.

    You will have to convert dates to a date type before using and date comparison functions however. This can be done within a transformation if required.