Description
When editing a pattern for a HyperIntelligence card using pattern matching, the object or attribute form with a Double data type will lose its leading zeros, if there are any.
Steps to reproduce
- Import a dataset with a numeric column via Data Import and save it as a cube.
- In Workstation, build a card with the newly saved cube.
- In the Card Editor, enable pattern matching.
If your object or attribute form begins with zeros, they will not appear. For example, if your attribute form is 0012345, it will be displayed as 12345. Notice the leading zeros are not shown.
Why is this happening?
Numeric objects or attribute forms have a default data type of "Double," which will cause the leading zeros to be excluded.
Solution
Change your data type from Double to Text via Data Import or when preparing data.