Hi @Comunity I am performing audience export. Email address field in audience export, where some the values are null in exported csv file. When SFMC automation takes this file, it gives error where emailaddress = 'null'.Could you suggest how can i make this field as blank ?Already tried below.1. Add...

Hi Brekrut,Thanks for the response.I have already tired this and always got blank values. I am creating a scheduled query to fetch segementid , segmentName and segment status from profilesnapshot and segmentsnapshot and storing it in profile and upsert enabled dataset.I am struggling to fetch segmen...

Hi @AmarapuramMahesh @Community I am exporting segment membership data like segment id and segment status. below query work for segment id. SELECT workEmail.address as email ,EXPLODE(segmentMembership.ups)FROM profile_snapshot_export_* )) Can I fetch both segment id and segment status like "realized...

Thanks @DavidRoss91  it really help.

Hi @DavidRoss91 Thanks for the response.Could you please let me know to mark schema as un-usable?Regards,Santosh

Hi All, Do we have this feature of deleting profile enabled schema ? is there any workaround of getting rid of unused schemas ? Regards,Santosh

Hi Ankit,Thanks for reply.I am exporting other profile attributes as well with segment defemination, and want it iin attribute mapping. Cant I get this while mapping.Approach you suggesting is to create a temp table, extract segment name from "profilesnapshot" table, ingest into temp.and refresh it....

Hi Community,I want to export segment name to SFTP. I find segment name in union schema as  "xdm:timeSeriesEvents.segmentList.segmentName".. When I export I get null. Please suggest how can i get multiple segment name for same profile. Thanks in advanceRegards   

yes field value was getting overwritten with null values.so it was not coming in Audience mapping and audience creation.

Hi Community,Thanks for the reply.I fixed it, as the same attribute was part of earlier created dataset, I could it in union schema. it was having null value against it for older dataset. I ingested some dummy values in the older dataset and it start appearing in audience creation and activation. Re...