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 |
---|---|
196 | |
124 | |
88 | |
49 | |
42 |
User | Count |
---|---|
285 | |
162 | |
138 | |
77 | |
73 |