Forum Discussion
Separate information into columns
Hello
I'm trying to create a database with a JSON file, I've already managed to reduce all the information to a column where it has the name of the variable and the corresponding list.
Is it possible to automatically create a column with each of the lists and have the name of the variable be the title?
Hi Anonymous ,
1. Ensure that the JSON data is in a format that can be imported. If you are using Microsoft's Real-Time Analytics or a similar platform, you can introduce JSON files directly.
2. To determine the column division of the JSON data, select Advanced > Nested Levels, in the range of 1 to 100. For more information, refer to the documentation: Get data from file - Microsoft Fabric | Microsoft Learn. For more information, refer to the documentation: Get data from file - Microsoft Fabric | Microsoft Learn
3. If you need to further customize or transform the data after it has been introduced (e.g., rename columns, change data types), consider using a data transformation tool or writing custom scripts in the database management system.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
1. Ensure that the JSON data is in a format that can be imported. If you are using Microsoft's Real-Time Analytics or a similar platform, you can introduce JSON files directly.
2. To determine the column division of the JSON data, select Advanced > Nested Levels, in the range of 1 to 100. For more information, refer to the documentation: Get data from file - Microsoft Fabric | Microsoft Learn. For more information, refer to the documentation: Get data from file - Microsoft Fabric | Microsoft Learn
3. If you need to further customize or transform the data after it has been introduced (e.g., rename columns, change data types), consider using a data transformation tool or writing custom scripts in the database management system.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.