Jump to content

How can I work with messy Excel files in TIBCO Data Science Team Studio

Recommended Posts

Question submitted on behalf of a customer...

Let say I have Excel with a description column. And description column contains new line, its giving me error that columns are not consistent. You can have a look over the following attached .csv file for reference.

I've reproduced this problem with a simple Excel file that looks like this...

Text ID

Some text 1

Some text

with a newline 2

How do we work with columns that contain newlines And how do we work with Excel files

Link to comment
Share on other sites

Hey There!


Great question, we have an Import Excel operator that is able to correctly handle excel files with carridge returns/ new lines. You can take a look at this video for more information on how to actually achieve this in Team Studio.



Hope this helps!



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...