Generate Nested JSON from table

[Fatman121]

Hi everyone!

I have table like this format:

Name	Value
Name1	Value1
Name2	Value2
Name3	Value3
Name etc	Value etc

I need generate JSON from this table in format like: 

json = {
   "Name1": "Value1",
   "Name2": "Value2",
   "Name etc": "Value etc"
}

How can I do it with PowerQuery?

[ImkeF · Accepted solution]

Hi @Fatman121 ,

you have to transform your table to a record, then use Json.FromValue to transform to a JSON (in binary) and then back to text with Text.FromBinary:

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclTSUTI0UIrViVZyAjKNgMxYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t, Value = _t]),
    TransformTableToRecord = Record.FromTable( Source ),
    TransformToJsonBinary = Json.FromValue(TransformTableToRecord),
    RetrieveText = Text.FromBinary( TransformToJsonBinary )
in
    RetrieveText