Forum Discussion

HUEyoung's avatar
HUEyoung
New Member
3 years ago

how can i get record value raw text?

let
source = Json.Document(File.Contents("text.json")),
tabled = Table.FromRecords({source})
in
tabled

 

so this query shows

 

a.            b.          c.   

value.     List.        Record

 

i want show :

 

a.           b           c.    

value.    [a,b,c].    [{a : 4, b : 5, c :6}, [a : 5, b : 7, c :7}]

 

i can List show, but i cant show Record like this.

 

what can i do? 

 

before json to table, extract object raw string first? 

 

i cant find function. help !!