Jump to content
We've recently updated our Privacy Statement, available here. ×

Bug Spotfire inserting blank spaces in String (import data)


Luiz Eduardo Zappa

Recommended Posts

Hi,

I'm having a problem with connecting Spotfire to PostgreSQL database. When the load method is "Keep data external" ever thing is fine, but when the load method is "Import data" then spotfire is inserting blank space to reach the string max lenght, resulting in right blank spaces in all string columns. It's a pain to trim all columns.. Is this a bug

 

Is there a fast way to trim all columns

 

Thx in advance

Link to comment
Share on other sites

To verify this, I would suggest you to create a case with TIBCO Support if you have access to it.

 

Apart from that, where exactly you see leading blank spaces (Column names in table plot, column data in table plot, columnn names in Column Properties) Would you be able to share screenshots that show the difference If so, I can take a look to see if there is any workaround.

Link to comment
Share on other sites

Shashank Gurnalkar,

I figure out the erro, it was in Postgre database, the type of the column was character, so the postgree was inserting blank spaces to complete the string lenght defined. I changed the type to text, and now is working as expected.

Anayway, the error was in data table view (column values), i've attached the image.

The two load methods ("Keep data external" and "Import data" ), imports with blank spaces. The difference is that the "Keep data external" has a function Leftstr() that seems to disregard blank spaces, so i did a calculated column with logical teste If(Leftstr([ColumnA]) = "XX",true,false) and everthing was ok. When a i changed the load method to "Import data", the function Lefstr() ceased to exist (why), and i have to use Left() (I think it doesn't deal with white space, so the logical tests were wrong). In this step i've noticed that the string columns were imported with blank spaces.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...