在Power BI中解析.json列
发布时间:2020-12-14 05:14:53 所属栏目:大数据 来源:网络整理
导读:我想通过Power BI解析.json列.我直接从服务器导入数据,并在数据中包含.json列以及其他列.有没有办法解析这个json列? 例: Key IDNumber Module JsonResult 012 200 Dine {"CategoryType":"dining","City":"mumbai"',"Location":"all"} 97 303 Fly {"Journey
我想通过Power BI解析.json列.我直接从服务器导入数据,并在数据中包含.json列以及其他列.有没有办法解析这个json列?
例: Key IDNumber Module JsonResult 012 200 Dine {"CategoryType":"dining","City":"mumbai"',"Location":"all"} 97 303 Fly {"JourneyType":"Return","Origin":"Mumbai (BOM)","Destination":"Chennai (MAA)","DepartureDate":"20-Oct-2016","ReturnDate":"21-Oct-2016","FlyAdult":"1","FlyChildren":"0","FlyInfant":"0","PromoCode":""} 276 6303 Stay {"Destination":"Clarion Chennai","CheckInDate":"14-Oct-2016","CheckOutDate":"15-Oct-2016","Rooms":"1","NoOfPax":"2","NoOfAdult":"2","NoOfChildren":"0"} 我希望保留其他列,并获得简化的解析列. 解决方法
像这样使用Json.Document函数
let ... your_table=imported_the_data_directly_from_the_server,json=Table.AddColumn(your_table,"NewColName",each Json.Document([JsonResult])) in json 然后使用Table.ExpandRecordColumn将记录扩展到表 或者单击此按钮 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |