Change the setting on the Aggregator Attribute Accumulation Mode to 'Merge Incoming Attributes' insetad of 'Use Attributes From One Feature'.

@jdh

thanks for your replay,

it didn't work I am still getting only 2 attribute _attr_name and _attr_value,

You want to restore the original features?

@boubcher Are you able to include a small sample dataset - that will help take the guesswork out of understanding why your results differ from the example in the article Transpose a Table Using FME.

this is the input to the workspace

after attribute exploder we get this

we want to reconstruct the attribute as the input

we applied the aggregator but still not getting the expected result

@markatsafe

thanks for your response please find attached the template workspace

please take a lool

explode and aggragate.fmwt

@boubcher Thanks for including some sample data. In the article Transpose a Table Using FME the AttributeCreator is used to set the attributes from the list created in the Aggregator. This is easy enough to do for only a few columns. But your sample data has about 150 columns per row. Each Aggregated feature has the list:

It is probably easiest to write a Python Script to rename the columns to the __owner and the list{}._attr_name to the value of the attribute. Perhaps someone in the community will pickup the challenge for you...