What is returned is two lines for each tx-id. To do this click on the arrows on the top of the column and select Expand to New Rows. Next, we need to expand this list to new rows. Power query will recognise the first [ and create a list format. To parse the json column, first select the column, then on the Transform Ribbon select Parse and select JSON On the canvas you can see your data and, on the right, you can see any transformation steps that have taken place. Select the cells the contain the data and tick the box to say that your table has headers. If your data is not in table format, Excel will then prompt you to create a table. For Example ]Ĭlick on any of the cells that contain the data and from the Data Ribbon select FROM Table/Range An object being a name/value pair separated by a comma. ![]() ![]() For Example “name” : ”paulag”, “Sex” : “Female”
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |