How to get audience origin data using query in a new dataset

[ShivaniM]

Hello Experts, 

I'm trying to create a dataset which has details like person_id, its qualification time in the audience, status and audience_name, audience_ID and audience origin.

In  segment_ingestion_dataset deatset I'm able to see audience's origin as (AO, AEP segment etc) which I want to ingest in a new dataset. While using c.origin it is giving me error.

Could someone help me modify this query to get audience origin as well:

Select
c.id as SegmentID,
SegmentName, _repo
from
(
select
explode (b) as C,
SegmentName, _repo
from
(
select
explode_outer (a) as b,
SegmentName, _repo
from
(
select
map_values (IdentityMap) as a,
SegmentName,
-- segmentStatus,
_repo
from
segment_ingestion_dataset

)
)
)
(it is the part of that query)

[supratim320]

Can you share the error! Also in terms of debugging, I can see "segment_ingestion_dataset" is at the inner most query, so is that one failing?

To add further, I do not see "origin" field in this dataset, I guess you have to share most of the query for debugging.

[Supriya_Savre]

Hi @ShivaniM,

Did the shared solution help you out? If yes, kindly consider marking the answer as ‘correct’.

If you’re still facing any challenges, please feel free to continue the conversation here. Or if you've discovered a solution yourself, we would appreciate it if you could share it with the community.

[kautuk_sahni]

@ShivaniM Just checking in — were you able to resolve your issue?
We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!