I want to split the fields into individual event for the below Jso n file. ... View more

Dear Experts, Please provide a valuable solution for my problem. I am having the fields from JSON which is having multivalue fields as below. In below example Department field having three values and Projects field having 5 values. I want expand this. Name | EMP NO | Department | projects ABCS | 1234567 | CS12345678 | PROJ1 | | AB12345678 | PROJ2 | | AB55555555 | PROJ3 | | | PROJ4 | | | PROJ5 I need output like the below Name | EMP NO | Department | projects ABCS | 1234567 | CS12345678 | PROJ1 ABCS | 1234567 | AB12345678 | PROJ2 ABCS | 1234567| AB55555555 | PROJ3 ABCS | 1234567 | NULL | PROJ4 ABCS | 1234567 | NULL | PROJ5 ... View more