Deleting a column permanently from OAC

DiDio

Summary:

This may be a stupid question but I cannot figure out how to delete a column completely from a dataset once the initial load is made via xlsx. or csv.

Content (required):

Sometimes columns of data can be added or removed. When a column is removed from the csv or xlsx. file and i go to upload it in oracle, i often get an error saying oracle cannot find the column. It's looking for a column that no longer exists. How do I go into OAC and delete that column so I am able to upload my data set?

For example. Say initial dataset loaded has columns A,B,C,D data.

Then 2 weeks later Column B is no longer needed so it's removed.

Next dataload will be columns A,C,D

When you attempt to load this data, OAC errors out because it's still looking for column B which doesn't exist. How do I get OAC to stop looking for column B?

I'm wondering if this is a glitch and if Oracle is aware.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Amrita Gupta-Oracle

Hi,

Have you tried deleting the column from the data set, like below? To get to this page, open your Data Set to Edit it.

You can then, remove the column from the .xlsx/.csv file and uploading it again.