7. How to convert a JSON record into NESTED JSON using mapping dataflow

Опубликовано: 23 Февраль 2026
на канале: Azure Content : Annu

2,175

In this video we learnt how to convert a JSON record into NESTED JSON using mapping dataflow
#adf
#azuredatafactory
#datafactory
#azuresynapseanalytics

Input dataset:
{ITMNBR=9011817, BARCODE=M523270,SEQNO=11, DESC=TUBE,GAS,FRMD,SIMMER , SERIALNO=9046229}
{ITMNBR=9011817, BARCODE=M523270,SEQNO=15, DESC=PANEL,SIDE,MNTG , SERIALNO=9037611}
{ITMNBR=9011817, BARCODE=M523270,SEQNO=12, DESC=ORIFICE,ASSY,18K , SERIALNO=9035246}
{ITMNBR=9011818, BARCODE=M523275,SEQNO=01, DESC=W_H,MANF,ICB , SERIALNO=9031413}
{ITMNBR=9011818, BARCODE=M523275,SEQNO=05, DESC=RECEPTACLE,BEZ,DF , SERIALNO=9009061}
{ITMNBR=9011818, BARCODE=M523275,SEQNO=18, DESC=BRACKET,MNTG , SERIALNO=9037907}
{ITMNBR=9011818, BARCODE=M523275,SEQNO=13, DESC=MANIFOLD,A , SERIALNO=9008632}

Output dataset:
{ITMNBR=9011817, BARCODE=M523270, ITEMLIST=[{SEQNO=11, DESC=TUBE,GAS,FRMD,SIMMER, SERIALNO=9046229}, {SEQNO=12, DESC=ORIFICE,ASSY,18K, SERIALNO=9035246}, {SEQNO=15, DESC=PANEL,SIDE,MNTG, SERIALNO=9037611}]
{ITMNBR=9011818, BARCODE=M523275, ITEMLIST=[{SEQNO=01, DESC=W_H,MANF,ICB, SERIALNO=9031413}, {SEQNO=05, DESCRECEPTACLE,BEZ,DF, SERIALNO=9009061}, {SEQNO=13, DESC=MANIFOLD,A, SERIALNO=9008632}, {SEQNO=18, DESC=BRACKET,MNTG, SERIALNO=9037907}]