 Hello, Welcome to SSUniTech, so see this side and in this video we are going to see how we can load the data from the JSON file with the nested hierarchy to the CSV file. So what is the JSON with the nested hierarchy? First we need to check about this and after that we will see how we can load that into the CSV file. So let me go into the source file so we can see the data for sales. So here we are having the data for the sales as we can see the SOID, then the sales order date, then the country. After that we are having this nested hierarchy of the JSON. So this is one of the JSON and it is having the data for the item, quantity and value. So this is one of the JSON which is inside the whole JSON. So for example here we are having SOID, SODate, country and under the sales item, quantity and value. So in the CSV file we will be having six columns with the SOID, SODate, country, item, quantity and value. We will not be going to keep the information like we are having here. So how we can convert this we will see in this video. Let me go into the browser and we will try to implement this in practical. This file is already available in the input blob storage and with the name of sales.json as we can see here. Let me go into the SEO data factory and we will try to implement this in practical. So let me try to add a new data flow here. So this data flow let me call this data flow as load from JSON to CSV. Now first we need to add the source. So let me try to create a new data set here. So click on new as your blob storage click on continue and the file which is the JSON file so we can select the JSON file here and click on continue. And here let me call this as data set for the sales underscore JSON format link service we have already created so let me use the same then we need to select the file. So let me try to browse this go to the input folder and after that we can select the file which is the sales dot JSON file. Let me click on OK. Here everything is OK we can click on OK. So this data set will be created. So as we can see everything looks OK. Let me go into the source option and under the source option if you can scroll in the bottom side then we can see the JSON setting. So if we open this then document form which is the document per line but it is area of document because we have the nested JSON under that file. Now let me go and try to check the data. So we will be going to see the data. So as we can see the SOID SO date and country is coming correct but under the sales here if we can click then we can see total three of the sales. So it is having the item quantity and value similarly for the second third. So all these are having data like this. So as of now this data is the complex type of an array. So we need to convert this as an string data type. So how we can do that as we have already discussed about the flattened transformation. So we have to use the flattened transformation to convert this array into the string values. So here we need to select the enrolled by. So under the enrolled by we have to select the sales as we are having this sales column into the source. So we can select this after that here we can see the enrolled root. So here we can also select the sales. So by which we want to unroll this. So let me try to go in the bottom side and here we can see the sales is mapped with the sales. So we don't want to map sales with the sales. So how we can add the item quantity and value. So once we click on this sales then it is having the item. So we can select the item. Let me add another mapping and that mapping will be for quantity. So here we can select the quantity. Similarly let me add another mapping. So this mapping will be for value. So everything is coming from the sales table. So as we can see so let me try to rename this column as item. So now we will be going to have the value for the SOID SO date country item quantity and value. This item quantity and value is coming from the sales. So let me go into the data preview and try to refresh. So we will see the data here. So it should be having six column with the item quantity value SOID SO date and a country. So here as we could see SOID SO date country item quantity and value. So now it is having the data as per expected. Now let me try to add the sync here. So under the sync we will be going to add the data into the output folder of the blob storage. So for that let me try to create a new data set as your blob storage and we want to keep the data into the delimited text file. So we can select click on continue. After that here we need to select the link service. Then we need to browse and here let me go into the output folder and select that first row as header. So we can select this checkbox. Let me click on OK. So delimited text one data set will be created for the destination. Here if we can go into the setting then we can see the option the file name. So we want to keep into the single file. So we have to specify the name so that is for the sales underscore JSON dot CSV something like this. We need to set the single partition and now we can set this. So it will be going to saved. In between let me try to add a new pipeline and under this pipeline as we can see this is saved so we can drag and drop this and we will be going to execute. So once it will be executed your JSON file will be loaded into the CSV file in the output folder of the blob storage. So this is in progress so let me try to refresh it. So as we can see it got executed successfully. Let me go into the Azure blob storage and go to the output folder of this. So here we can go into this container of the output folder and here we should see the file. So we can check sales underscore JSON dot CSV file. So this is the file. If we can go into the edit then we can see the data here everything is coming as expected. So thank you so much for watching this video. In the next video we will be going to convert the CSV file that we have generated in this video into the JSON with a nested hierarchy. So we will do the reverse what we have done in this video. See you in the next video.