IBM Data & AI

Welcome to the idea forum for IBM Data & AI (Formerly Analytics) Clients! 


IBM Employees:

The correct URL for entering your ideas is



Our team welcomes any feedback  and suggestions you have for improving our offerings / products!  This forum allows us to connect your offering / product improvement ideas with IBM product and engineering teams.


If you have not registered on this portal please click on the following link and register.  To complete registration you will need to open the email you will receive from Aha to confirm your identity.


Automatically trim leading and trailing spaces from Variable Names

A colleague was struggling with getting a Time Series model to work.  The issue turned out to be that there were leading and trailing spaces on the target variable name.  I have seen this happen with client data in the past.  The error message that Modeler generates is non-obvious and is not mentioned in the resolution for that error. [2018-08-23 12:26:42] AEQAE1004E: Unable to complete the request. Reason: Reduce Execution error - The field name Expenses is not valid. I can't think of any good reason for a variable name to have spaces, so it seems like trimming them automatically would be a good solution.

  • Cheryl Howard
  • Dec 14 2018
  • Future Consideration
Customer Name
Role Summary Modeler User
  • Attach files
  • Guest commented
    December 14, 2018 18:00

    One of the easiest fixes might be changing the error message to something like, 'check formatting of field names'. However, I would agree with Cherlyl that the best fix is to remove leading and trailing spaces.

NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "anonymous@euprivacy.out" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions