An empty array is being stored as '0'. | Community
Skip to main content
Level 2
May 29, 2025
Question

An empty array is being stored as '0'.

  • May 29, 2025
  • 0 replies
  • 230 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.