1

I am trying to convert data from a CSV file to JSON with nested array. I want the following source data

JobId   JobDate  Skill     SkillCluster
1   20122019     100        SkillTest1
1   20122019     200        SkillTest2
1   20122019     300        SkillTest3
2   21122019     1200       SkillTest21
2   21122019     2200       SkillTest22
2   21122019     3200       SkillTest23

to be converted into below JSON using Azure Data Factory.

[{
   "JobId": 1,
   "JobDate": "20122019",
   "Skills":[{
   "Skill":100,
   "SkillCluster": "SkillTest1"
   },
   {
   "Skill":200,
   "SkillCluster": "SkillTest2"
   },
   {
   "Skill":300,
   "SkillCluster": "SkillTest3"
   }]
 },
{
   "JobId": 2,
   "JobDate": "2112019",
   "Skills":[{
   "Skill":1200,
   "SkillCluster": "SkillTest21"
   },
   {
   "Skill":2200,
   "SkillCluster": "SkillTest22"
   },
   {
   "Skill":3200,
   "SkillCluster": "SkillTest23"
   }]
 }]

I can see JSON array can be read and flatted but I am trying to achieve the reverse of it."

0 Answers0