I am trying to get from a table like this example:
to this table:
I have searched for answers but can't fully seem to get where I need to be- including trying variations of attribute transposer, attribute exploder, attribute exposer, and attribute pivot (this helped me get closer to the answer but didn't allow for text..). Any advice would be much appreciated!
Best answer by nielsgerrits
AttributeCreator to create attributes from attributes
Set Parameter as AttributeName
Set Value as AttributeValue
AttributeExposer to expose attributes created in previous step
Aggregator to merge the rows with same objectid in one line.
Group by ObjectId
Merge attributes.
Exposing the attributes can not be done automatically. If you want to do this automatically you can use a SchemaScanner and write the data dynamic.
Thank you for a prompt response. This successfully creates the columns, however values are still in the value column rather than in the corresponding columns created. Is there something I am missing?
Thank you for a prompt response. This successfully creates the columns, however values are still in the value column rather than in the corresponding columns created. Is there something I am missing?
Thank you in advance.
Almost there. In the AttributeCreator, you need to click the second arrow, select Attribute Value, then Paramater, so the field displays @Value(Parameter).
Thank you for a prompt response. This successfully creates the columns, however values are still in the value column rather than in the corresponding columns created. Is there something I am missing?
Thank you for a prompt response. This successfully creates the columns, however values are still in the value column rather than in the corresponding columns created. Is there something I am missing?
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.