https://arup.sharefile.com/d-saeccd70feea46d6b
Thanks
Question
Summarising an OD matrix
Hi - I have a larger OD matrix to the file shared below (too big for excel to handle) and would like to aggregate all the duplicate zones together (to produce the matrix shown in the 'summarised' tab. Would anyone be able to provide a solution/script in FME?
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+15- Contributor
Hi,
Here is a way to do it.
You need to be aware that the FME excellreader will add a order number to columns with sme name. To cope with this i added a stringsearcher and a NullAttributeValueMapper. Latter because the normal ValueMapper does not allow for regexp.
The csv can be converted to excell using a simple:
For automation you can call the latter at the end of the fomr workbench usiing a workspacecaller.
..for some reason the Excell reader fails to read coulmn 1022..hav'nt solved that yet, alas.
+15- Contributor
Hi,
Here is the orrect version.
(your sample has different attributes for rows and columns..) I now keep the original row_names.
Also added a "totals" row to the sheet.
When written to excell (Csv2Excell)
Hi Gio
Thankyou so much ! I didnt expect anyone to go to so much effort. Much appreciated- this will be very handy for the future :)
Is there a way to show the script in a higher resolution? I can't make it out fully..
Thanks
Zoe
+15- Contributor
..added another statcalc for totals per row. Also inserted wsc for csv to excell:
result:
...ok..now back to work... :)