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.
Solved! Go to 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 🙂
After changing the CDS column did you also make any changes in the Excel columns?
No, I haven't done any change on excel.
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.
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 🙂
User | Count |
---|---|
174 | |
115 | |
86 | |
44 | |
41 |
User | Count |
---|---|
238 | |
150 | |
132 | |
77 | |
73 |