Hi

Have you looked at the AttributePivoter?

David

There are a lot of posts on the forum showing soltuions.

Pivoter is ..usable

You still have to expose the attributes.

Best use a attribute exploder, remove fme-attributes, expose xls_row id.

Create a csv or txt-file.

Examples of this on forum as wel.

Hi,

Alternatively, you can merge all the data by adding rows for each date then do transpose in one-shot for entire data as shown in below link

https://knowledge.safe.com/articles/1315/advanced-...

Pratap

Hi,

I have followed the "vegetable" example in the above link. It works nice. However, if I understood it correctly, it requires knowing the number of records before the script is run to properly feed the attribute creator. I adapted it to my case with , at the Moment, 4 files and it works nice:

The resulting file looks like this:

However, I will have more files to process (by the time of the script run I will not know how many!), each of which will require an additional column with a date value! This seems requireing a loop approach. I tried to dig the "ListPivot.fmx" of the Forum, but I am not successfull.

I played around with the attributepivoter, but it does not bring me any further.

Some more ideas?

@femo, did you figure out a way to loop this process? I'm trying to do something similar, but I will not know how many date value columns I will need to add. Thanks!