AEP - ODE - Profile and Offer Export

[navink386520]

With in AEP, is there a way to export both Profile and Offers together. i.e I am looking for an output, where Example given below

ProfileID	OfferID	OfferID
id1	ofid1	ofid2

Challenge, I see is Offers (Decision Object Repository - Personalized Offers ) dataset is missing my Pkey with-in Record Schema. 

[Danny-Miller · Accepted solution]

Try looking at this, it basically points you to the dataset and Query Service.

Here is some starter SQL, but you may need to reconsider your output data structure.

select identityMap, 
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.ACTIVITY.NAME, 
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.ACTIVITY._REPO.ETAG,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.ACTIVITY.ID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.PLACEMENT.NAME,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.PLACEMENT.CHANNELID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.PLACEMENT._REPO.ETAG,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.PLACEMENT.ID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.FALLBACK.NAME,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.FALLBACK._REPO.ETAG,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.FALLBACK.ID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.SELECTIONS.NAME,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.SELECTIONS._REPO.ETAG,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.SELECTIONS.ID,
_EXPERIENCE.DECISIONING.PROPOSITIONDETAILS.SELECTIONS.SCORE
from ode_decisionevents_xxxx
where _ACP_BATCHID = '[guid]'
limit 10