An empty array is being stored as '0'.

[JettyRo]

I have one field mapped into AEP Inbound flow through a calculated field.
Field - fieldofplay[] string array type
Calculated field formula - 
iif(_eycom.personDetails.fieldOfPlay[0] != '',_eycom.personDetails.fieldOfPlay[0], '') +
iif(_eycom.personDetails.fieldOfPlay[1] !=  null, ', ' + _eycom.personDetails.fieldOfPlay[1], '') +
iif(_eycom.personDetails.fieldOfPlay[2] !=  null, ', ' + _eycom.personDetails.fieldOfPlay[2], '') +
iif(_eycom.personDetails.fieldOfPlay[3] !=  null, ', ' + _eycom.personDetails.fieldOfPlay[3], '') +
iif(_eycom.personDetails.fieldOfPlay[4] !=  null, ', ' + _eycom.personDetails.fieldOfPlay[4], '') +
iif(_eycom.personDetails.fieldOfPlay[5] !=  null, ', ' + _eycom.personDetails.fieldOfPlay[5], '') +
iif(_eycom.personDetails.fieldOfPlay[6] !=  null, ', ' + _eycom.personDetails.fieldOfPlay[6], '') +
iif(_eycom.personDetails.fieldOfPlay[7] !=  null, ', ' + _eycom.personDetails.fieldOfPlay[7], '') +
iif(_eycom.personDetails.fieldOfPlay[8] !=  null, ', ' + _eycom.personDetails.fieldOfPlay[8], '') +
iif(_eycom.personDetails.fieldOfPlay[9] !=  null, ', ' + _eycom.personDetails.fieldOfPlay[9], '')

Input –

Output –

select workEmail.address,_eycom.personDetails.fieldOfPlay,_eycom.salesTeam.additional_relationship_owners from stage_lens_contact_dataset where _acp_system_metadata.acp_sourceBatchId in ('01JW8SGDP6RRR44053YR8QKFSV')

Input –

Output –

select workEmail.address,_eycom.personDetails.fieldOfPlay,_eycom.salesTeam.additional_relationship_owners from stage_lens_contact_dataset where _acp_system_metadata.acp_sourceBatchId in ('01JWB7DZQ7KNQZEQ08N2X8N6M5')

can some one tell me why it is taking empty array like '0'. is it supposed to happen?

could some one explain this behaviour of AEP.