Hi,
I have to import an excel file using data entity. It has only 1 column.
let's say it as 'A', in it which actually does not exists as a field on the target table. In fact, this column contains data for 3 separate fields of the target table. That means I have to split the data of this column and update 3 fields of the target table. How to achieve this? The data is not separated with any specific character. It's a data of a particular character length using which I am going to split them.
Looking at this MS Documentation, I created a data entity which has datasource of the target table. I created a virtual field in the data entity for this column 'A'.
Computed columns and virtual fields in data entities - Finance & Operations | Dynamics 365 | Microsoft Learn
My Problem:
I created Import project and added the entity. Now, when i go to mapping the fields, i can see column 'A" in 'Staging field' but there is nothing to map it in the 'Source field' column. So how and where to map column 'A'.?
If I don't map column A, How does my entity know that which column from Excel is being used as a Virtual Field of the entity? How will I get the data of this column A in the mapEntityToDataSource method as shown in the MS article above?
