Can I change a DataLink schema without removing columns?

Follow

Saurabh Agashe

• April 10, 2015 17:59

Hi, Here's the situation where I'm stuck, and hoping someone can help:

I created a Data Link and built a bunch of workbooks using it. Everything worked fine. I recently found that one of the columns in my schema might be empty, so I need to update the DataLink to mark that column as "Accept Empty" so that Datameer won't toss out those records. However, when I go to configure the the DataLink, I find that Datameer rescans the data and is removing some other columns that I had previously in the DataLink. I know those column will be there in some records.

Is there a way I can just mark my one column as "Accept Empty" without Datameer rescanning or changing any other fields in the schema?

Thanks for any help!

0

• Official comment

  

  Saurabh Agashe

  • April 10, 2015 17:59

  Hi there!

  When going through the Datameer wizard, the schema will be rescanned at that time. If columns no longer exist in the source data, they will not be displayed in the wizard.

  However, there is a way to update a data link definition using the REST API. With this, you could export the current JSON settings, update the Accept Empty value for the desired column and then push the new JSON to a copy (or overwrite the original) Data link. Documentation for the REST API will contain the commands and syntax to use to read and write the Datalink definition.

  Comment actions Permalink

Please sign in to leave a comment.