Hello! I'm trying to write the values from several attributes into an excel file. I want all values on the same row, now I'm getting them in one row after another.
Any ideas on how to do this?
Regards,
Louise
Hello! I'm trying to write the values from several attributes into an excel file. I want all values on the same row, now I'm getting them in one row after another.
Any ideas on how to do this?
Regards,
Louise
Hi, yes aggregate them into one with the aggregator.
Hi, yes aggregate them into one with the aggregator.
Thank you! But I don't really understand how this will help me. I want them on the same row but different columns. I have been trying to do this with setting which row to write on. Is there some way of specifying row and column? I have the 2014 version.
FME writes one feature per row in your Excel file, so the key is to have all the attributes in the same feature if you want them all on the same row. The Aggregator is one way of "accumulating" all the attributes from several features into one feature.
On the Excel writer you should then define the attributes in the order which they (the columns) will appear in the Excel file.
Thank you! Now it works.