How to create this table with json arrays

[VasistaI]

hi i'm new to splunk. need some help.
I have below script: 

| spath input=message
| search env=prod clAppNam="i-app" demographics.firstName != null 
| table usrId, pId, email{}.emailTypeCode,email{}.emailAddress
| outputcsv Upsert_party_Address_Report

 

This results in below report:
usrid  pid    emailTypeCode   emailAddress

1          222  home                        [email protected]

                       work                        [email protected]

1          333  work                        [email protected]

                        correspond         [email protected]

1          444   home                     [email protected]

I need the results as shown below.. 

usrid  pid    emailTypeCode   emailAddress

1          222  home                        [email protected]

1          222  work                        [email protected]

1          333  work                        [email protected]

1          333  correspond         [email protected]

1          444   home                     [email protected]

Any help is greatly appreciated..

[somesoni2 · Accepted solution]

Try like this

......
| spath input=message
| search env=prod clAppNam="i-app" demographics.firstName != null 
| table usrId, pId, email{}.emailTypeCode,email{}.emailAddress
| eval temp=mvzip('email{}.emailTypeCode','email{}.emailAddress',"##")
| mvexpand temp | rex field=temp "(?<emailTypeCode>[^#]+)##(?<emailAddress>.+)" | fields - temp
| rename emailTypeCode as email{}.emailTypeCode, emailAddress as  email{}.emailAddress
| outputcsv Upsert_party_Address_Report 

[VasistaI]

this solution worked. Thank you so much for the help!!

[richgalloway]

You're looking for the filldown command.

| spath input=message
| search env=prod clAppNam="i-app" demographics.firstName != null 
| table usrId, pId, email{}.emailTypeCode,email{}.emailAddress
| filldown usrId pId
| outputcsv Upsert_party_Address_Report 

[VasistaI]

unfortunately the filldown did not work..