Update schema for batch upload

[jooyeon_han]

Hi everyone, 

We don't have anyone using API at our company and doing things in AEP UI. 

We have existing schema, dataset, and scheduled batch files. (Field A,B,C)

Now we want to onboard a different file based on a same primary key. (Field D,E,F)

What we did was 1. Update existing schema by adding field D,E,F. 2) Created dataset based on that schema 3) upload sample data into the dataset. 

When we try step 3, I am keep getting 'A required field [_bellca] of type object is missing from the input data. Please add the required field and try again' Why is this? I am attaching screenshot of our network schema. 

The individual fields are the subset of each object. (_bellca being the highest hierarchy) Is there a step I am forgetting from the UI?

[DavidRoss91]

@jooyeon_han 

Does your input data file have the correct format? I.e. are your fields in this format?

_bellca.bellCustomerAttributes

_bellca.bellCustomerEligilityList

_bellca.bellCustomerIdentities

_bellca.bellUDFField

[jooyeon_han]

Hi @DavidRoss91 

Thank you for your reply. 

The existing batch fileA captures the fields that are associated to the first three hierarchy. (Each individual hierarchy has subset of fields and those are all captured).

_bellca.bellCustomerAttributes

_bellca.bellCustomerEligilityList

_bellca.bellCustomerIdentities

Now for the new batch fileB I would like to setup, the all fields that are associated to the last hierarchy (_bellca.bellUDFField) are included, including the primary key.

I thought when adding a new data source (new batch file), I should update the existing schema by adding the new fields that are coming in, and setup a separate dataset so when the new batch file is uploaded, it will do the mapping based on the primary key. 

I am very new to updating this and I am lost

[DavidRoss91 · Accepted solution]

@jooyeon_han sorry for the late reply here. In regard to creating a new dataset, I don't believe that would be necessary as it seems you are only trying to add a new object to an already existing schema. I.e. _bellca.bellUDFField is now included in the new file along with the original 3 objects. Could you provide an example of you input file? You can exclude any confidential information please.