Does anyone know if there is an ability in data designer where you can create a new field via transform that starts with a non-alpha character like % or #?
Welcome to the community,
You can most definitely create new fields, but the field name must have a first character which is alphabetical.
To add a field, in your Transform step, look for the buttons labeled Add Formula Field or Add Case Field.
Be aware that Data Designer will actually let you create the field, and build your formula / case expression, and doesn’t validate that “first character must be alphabetic” until you try to save the step. If that occurs, you can simply rename the field, perhaps leading with Number or Percent, as your data warrants.
Reply
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.