Import from SQL Receiving Error - "Anaplan API: Cell text cannot contain tab character"

We are attempting to switch our source from excel files to a SQL server and are receiving this error when running the scripts for Anaplan Connect. The job is successful for the initial two tables but we're experiencing this error on the final table. The formatting and configuration is similar for all tables so unsure why this error is occurring.

Does anyone have experience with this error?

Accepted answers

All comments

ben_speight

A column in your result set has a tab character. Anaplan Connect uploads JDBC as tab-separated data, so cannot deal with tab characters in fields. Perhaps you can edit the SQL to substitute them out?

JoanaNdreu

Hi @ben_speight I have got the same problem. How can I identify and substitute these tab characters?

ben_speight

Its likely to depend on the database used; for MySQL something like REPLACE(mycolumn, '\t', '') would remove any tab characters from a selected mycolumn.

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…