Date and others atribute association

[Bernardo_Santos1]

Hello team,

I'm currently testing the SAP Datasphere trial and building a test model with the attributes "Year" (Date), "Organica," "FF," and "Economica." However, when I preview the data, the Year appears merged with the other attributes.

Each attribute has its own key, and the Year is set as the primary key. However, as shown in the screenshot, the information appears concatenated. Is there a way to separate the Year from the other attributes without using code for now? If code is required, what would be the best approach?

Thanks for your time!

Bernardo Santos

[Martin_Kuma · Accepted solution]

Hey, seems like compounded key. Check the source data. At first glance, I see UTF-8 code page is not applied either. I would say, you upload the data as it is. In the model-view try to separate the content with sql functions like LEFT, RIGTH, ... into own fields. Back to the SQL basics :). Cheers, Martin