Please find the example below, which is the value of column that combines all relevant address information (attributes like PostCode, City, Address etc.):
As emerges, all different attributes are seperated by the ',' symbol.
Is there a solution to display each attribute at a seperated (read new) row?:
I need to apply this within a table!
Niels Thomsen Hi Jelle
If I understand you correctly all the information above is stored in one attribute? And what you are trying to do, is to separate one attrubute into a number of different attributes based on the fact the there is a delimiter (,) that can be used to identify where to split the data?
Jelle Jöerissen Hi Niels,
That is correct, but rather than seperating the attributes into different columns, I would like to have the results in rows within a table/crosstab.
Niels Thomsen Ok thanks. I think maybe the feature request here, is to be able to work on dimension data in general - do substring-like operations and so on?
Currently you can't do this is the frontend.
Your only option would be to build a table - use it as a data source in data discovery - do the text manipulation in that environment - and finally build your table based on a data discovery cube.
Jelle Jöerissen Hi Niels,
Thank you for the information!
In my opinion, the request is more about the possibilities of dimensional attributes within tables. Because basically, the goal is to improve the readability by formatting a dimension like address information (to allign it with the format of a postcard/letter).
Jelle Jöerissen Moreover, that (formatting/layout) is the only reason that all information is concatenated and stored into a single attribute.
Niels Thomsen ok - good point. Let's put the other idea in a different feature request.
Comments
6 comments