2
Hi,
I have my data in a CSV file and my column names corresponding to my data are inside the JSON file (Both are in D365 FnO). I need to map the column names along with the data, so that I can utilize in Microsoft Fabric.
Any assistance on this will be highly helpful.
Can I also get some assistance on Data Entity Framework regarding the same, to work on it.
You can use the Data Entity Framework for data mapping and integration. Here is a possible approach:
First, create a data entity framework that describes the data structure in the CSV file along with the corresponding column names.
Create a data entity framework mapping that maps the column names from the JSON file to fields in the data entity framework.
Import the CSV file and use the data entity framework mapping to automatically match the column names with the data.
In Microsoft Fabric, you can then access and utilize the data using the mapped data entity framework.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (