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
itay wrote:
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.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.