Creating Dataset using JSON

1. Click on Hamburger Icon.

2. Click on Documents Tab.

3. In Documents tab Click on Shared Resource.

4. In Shared Resource Click on upload, As shown in figure below:

5. When you click on Upload it will display a screen.

6. In Upload Files upload a JSON file, As shown in figure below:

7. Click on Upload button

8. You will get a message, As shown in figure below:

9. In Master Data Tab click on Dataset.

10. Click on create dataset, As shown in figure below:

11. Enter following details in Create Dataset.
Name: Employee JSON
Datasource: Existing Files
Select Employee(1).JSON file in Available to selected.

12. Fill above details, As shown in figure below:

13. Click on Preview and submit button.

14. You will see the Employee JSON Dataset, As shown in figure below:

15. Click on visualization Tab and open Dashboard.

16. From Right Vertical Menu Select the Table Widget icon.

17. The Edit menu box appears as you click Table Widget icon. And a widget gets added in content place automatically in dashboard.

18. Enter Following Details in edit box, As shown in figure below:
Dataset: Employee Json.ds
Select all the Field in Dataset Column.

19. Fill above details, As shown in figure below:

20. Click on Preview and Save and Exit.

21. Now, match your Table Widget with the below example, it should look like the figure below:


In this manner, you can create a new dataset for your datasource.

last updated date: 31-May-2021