Skip to main content
Question

Summarising an OD matrix

  • May 20, 2015
  • 6 replies
  • 78 views
Z
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?

 

https://arup.sharefile.com/d-saeccd70feea46d6b

 

Thanks

 

 
    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.

    6 replies

    gio
    Contributor
    Forum|alt.badge.img+15
    • gioContributor
    • Contributor
    • May 20, 2015
    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.

     

     
    gio
    Contributor
    Forum|alt.badge.img+15
    • gioContributor
    • Contributor
    • May 20, 2015
    ..i see, it 's a mistake on my part, will fix it later...
    gio
    Contributor
    Forum|alt.badge.img+15
    • gioContributor
    • Contributor
    • May 21, 2015
    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)

     

     

     

     
    Z
    • zoerhiannon
    • Author
    • May 21, 2015
    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
    Z
    • zoerhiannon
    • Author
    • May 21, 2015
    Never mind-sorted it out! I will test this out now :)
    gio
    Contributor
    Forum|alt.badge.img+15
    • gioContributor
    • Contributor
    • May 21, 2015
    ..added another statcalc for totals per row. Also inserted wsc for csv to excell:

     

     

     

     

    result:

     

     

     

    ...ok..now back to work... :)

    Community Stats

    32,724
    Posts
    124,149
    Replies
    41,216
    Members
    Terms & ConditionsAccessibility statement
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.