Bug in Importing Data from Excel to CDS Custom Entity

[VinothKJones]

I have created a custom Entity in CDS with 10 columns. I was able to upload data from excel with that 10 columns.

But I removed one column from that CDS and added a new column with a different name. Now my entity will again have 10 columns.

When I tried to upload data now I'm only seeing 9 columns, Not able to see the newly added column in Field Mapping while upload.

Attached screenshots for references.

[eka24]

After changing the CDS column did you also make any changes in the Excel columns?

[VinothKJones]

No, I haven't done any change on excel.

[eka24]

Kindly make the same changes to the excel and retry

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[VinothKJones · Accepted solution]

Actually I found that issue, Its not from Excel side, Its my mistake sorry for that.

The new column that I've added is a Lookup column from a new entity. I have missed to add Primary key to newly created Entity.

That was causing this problem. Now I identified and resolved that issue. 

Thanks for your Insights 🙂