本文介绍了将包含数组的JSON列拆分为多行的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

关于我的主题:https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2bdcbe98-8d0f-425d-9dd8-dbd20e005643/how-to-parse-a- json-column-into-multiple-columns-in-ssis?forum = sqlintegrationservices


附加样本数据集。



我已经将列解析为多个列,如ID,记录类型,创建时间现在,我想将数据集数组的名称/值对解析为多行。


我的代码应该转换:


{" ID":" f41dab","记录类型":20," CREATIONTIME":" 2017-07-23T10:18:40","操作":" ViewDashboard","工作量":" PowerBI","WorkSpaceName":"My Workspace","WorkspaceId":"My
Workspace","Datasets":[{" DatasetId":" 798038e9"," DatasetName" :" 2015年,时薪负荷和曲OT;},{" datasetID所":" 247"," DatasetName来":" export_waitstat1"},{" datasetID所":" F9E"," DatasetName来":" hydro_May18"}]


TO


ATTACHED IMAGE。



























解决方案

In relation to my thread:https://social.msdn.microsoft.com/Forums/sqlserver/en-US/2bdcbe98-8d0f-425d-9dd8-dbd20e005643/how-to-parse-a-json-column-into-multiple-columns-in-ssis?forum=sqlintegrationservices

Sample data set attached.

I am already parsing the column into multiple columns like ID,Record Type,Creation Time etc.Now,I want to also parser Datasets array of name/value pairs into multiple rows.

My code should convert :

{"Id":"f41dab","RecordType":20,"CreationTime":"2017-07-23T10:18:40","Operation":"ViewDashboard","Workload":"PowerBI","WorkSpaceName":"My Workspace","WorkspaceId":"My Workspace","Datasets":[{"DatasetId":"798038e9","DatasetName":"2015-hourly-loads"},{"DatasetId":"247","DatasetName":"export_waitstat1"},{"DatasetId":"f9e","DatasetName":"hydro_May18"}]

TO

ATTACHED IMAGE.





解决方案


这篇关于将包含数组的JSON列拆分为多行的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

07-23 03:44
查看更多