Forum Discussion
HUEyoung
3 years agoNew Member
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 !!
4 Replies
- wdx223_DanielCommunity Champion
hope this can help
- HUEyoungNew Member
ty but i need load json, not string
- wdx223_DanielCommunity Champion
could you please provide some sample data?