Schema Creation issue

Question

I have gone through the document and I am able to understand how to create a schema. I am practicing it on Sandbox.
Now I have added few fields which went under an Object datatype name : _adobecincoptrsd

Once, I am able to ingest the data in the schema it is successful but when I query it, it give me something like this:

But as per my understanding this data is making no sense as a new user will not be able to understand this.
What are the possible solutions to get this type of data in the form of rows and columns?
Thanks! In Advance.

arpan-garg · Accepted Answer

Hi @prabhakar_the_analyst - Yes this is how you see the data in datasets when you query them. What do you mean by saying that the user will not be able to understand the data? Who is the user here?

Thanks,

Arpan

Harveer_SinghGi1 · Answer

Hi @prabhakar_the_analyst ,When you use query service and use "select *" in your query it returns the first level of hierarchies in the XDM. If there are multiple sub-fields under the first level hierarchy it will show up values from all the sub-fields in a curly brackets as shown in your screen shot.To get any specific field you'd have to provide their complete path. In your example schema, if you are trying to read "Gender" then your query should have "select _adobecincoptrsd.EL_Demo_Details.gender" and so on for rest of the fields. With this each of these fields will show up as separate columns in query results.Cheers!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded