Hi,
I have a problem importing a json file into power query. A record looks like below. Expanding user and client is not a problem, new columns are inserted as they should, but expanding custom and orderRow, that are lists, inserts rows instead and I need to have them inserted as columns.
Haven't figured out how to do that, anyone who can help me?
Thanks!
Caj
<tbody>
I have a problem importing a json file into power query. A record looks like below. Expanding user and client is not a problem, new columns are inserted as they should, but expanding custom and orderRow, that are lists, inserts rows instead and I need to have them inserted as columns.
Haven't figured out how to do that, anyone who can help me?
Thanks!
Caj
Name | Value |
id | 1 |
description | Test |
closeDate | 2017-06-21 |
date | 2017-06-21 |
notes | |
user | [Record] |
client | [Record] |
contact | null |
project | null |
regDate | 2017-06-21T06:54:30.000Z |
stage | [Record] |
probability | 100 |
modDate | 2017-06-21T06:54:42.000Z |
clientConnection | null |
currencyRate | 1 |
currency | SEK |
locked | 0 |
custom |
<tbody>
[TR]
[TD]orderRow[/TD]
[TD]- [/TD]
[/TR]
[TR]
[TD]value[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]weightedValue[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]valueInMasterCurrency[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]weightedValueInMasterCurrency[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]agreement[/TD]
[TD]null[/TD]
[/TR]
[TR]
[TD]userRemovable[/TD]
[TD]TRUE[/TD]
[/TR]
[TR]
[TD]userEditable[/TD]
[TD]TRUE[/TD]
[/TR]
</tbody>
- [/TD]