Export Segment membership to SFTP

[SantoshRa5]

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 advance

Regards

[AnkitJasani29]

Hi @SantoshRa5 ,

You can export ids and map to names outside AEP or via Query Service you can ingest segment definition metadata into a dataset and export it to SFTP.

Thanks,

Ankit

[SantoshRa5]

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. please confirm.. 

Thanks in advance.

Regards,

Santosh

[AnkitJasani29]

Hi @SantoshRa5 ,
As far as I know, you cannot fetch segmentName directly through attribute mapping. To achieve this, you need to enrich the data (Example: using Query Service) by joining segmentMembership IDs with the segment definition metadata, and then export the enriched dataset.

Thanks,

Ankit