IBM Analytics Ideas

Welcome to the idea forum for IBM Analytics! 

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.  https://ibm.biz/AnalyticsIdeasPortalRegister

 

Option to preserve spaces in data.

We need to have an option to preserve spaces in between data.
Details of the symptom are explained in case TS000128469.
When you import a csv data into WEXAC, some data are structured with data like productID. That productID might contain a meaningful number of spaces such as "prod1 d1", "prod1    d1", "prod1        d1". But currently, when you import such data, all the spaces are replaced with a single space. (All data will be "prod1 d1")
Because of this behavior, we cannot search for data using productID which are no longer unique. Also, when WEXAC is used along with other software like Db2, it makes it impossible to search using productID. Db2 preserves number of spaces so no data match.(even with Microsoft excel).

We need to have an option to preserve spaces when importing such data.
If this option becomes available, it will be much easier and more flexible to use WEXAC especially when collaborating with other software or applications.

  • Guest
  • Mar 8 2018
Real Scenario + Problem Statement
Role Summary
Who would benefit from this IDEA?
Revenue Opportunity
Idea Priority High
How should it work?
Owning Tribe
Owning Segment
Submitter Tags
Customer
Geo - Use for OBDR Reporting only
Why is it useful?
  • Attach files

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