Donate Now Goal amount for this year: 3000 USD, Received: 1207 USD (40%)

Results 1 to 7 of 7
Like Tree3Likes
  • 2 Post By Mengelmn
  • 1 Post By Mengelmn

Thread: Dynamo List Sorting & Concatenating! I have the information, just wrong order! Help!!

  1. #1
    New Member
    Join Date
    January 14, 2013
    Posts
    4
    Current Local Time
    04:21 PM

    Dynamo List Sorting & Concatenating! I have the information, just wrong order! Help!!

    Hi i'm hoping someone can help me with this....?

    I have a basic schedule containing circuit information in revit like this...



    Ive done a dynamo script that gives me a list of the information i need to extract.



    what im trying to get to is a list that gives me the joined string of circuit number, rooms, comment.

    so based on the Revit schedule something reads like this:

    L11 - R.06/R.07/R.08/R.09/R.10/R.11 SP
    L12 - R.02/R.03/R.04/R.05/R.12/R.13 SP
    L21 - R.06/R.07/R.09/R.10/R.11 CL
    L31 - R.02/R.03/R.05/R.12/R.13 CL

    There are instances where there are 2 fixtures the same circuit in a room, but i dont want this room to be in the string twice.

    If anyone can help me with this i will be eternally grateful! i've wasting too much of my life on this already.

    Thank you in Advance!

    Script and revit file attached (2016).

    Attached Thumbnails Attached Thumbnails Dynamo List Sorting & Concatenating! I have the information, just wrong order! Help!!-revit-schedule.jpg   Dynamo List Sorting & Concatenating! I have the information, just wrong order! Help!!-list.jpg  
    Attached Files Attached Files

  2. #2
    Member
    Join Date
    May 30, 2015
    Posts
    200
    Current Local Time
    11:21 AM
    A little trouble following exactly what you are attempting to produce, but

    How are you extracting the data from Revit via Dynamo. Are you extracting the Schedule or the element data?

    Are you using rooms or spaces?

    Have you looked at “grouping by key”

    If you want each element to be an unique value, you will need another value, as based on your current information you would end up with duplicates.

    What you may have to do is combine the room values separately and then insert them into your concatenated values.

    If you can provide more clarity, maybe a image of your full graph more assistance could be provided.


    Sent from my iPhone using Tapatalk

  3. #3
    New Member
    Join Date
    January 14, 2013
    Posts
    4
    Current Local Time
    04:21 PM
    Hi Mengelmn,

    i'm extracting the element data into dynamo.

    im using spaces.

    what im trying to get to is the string of data mention in my OP, so i can push that back into another parameter as a circuit description.

    i do this normally by extracting the schedule into excel and sorting the data in there. but i wanted a more automated way without the excel export/import part.

    full image below...



    i have tried all sort, group by key, sort by duplicates, unique items.

    and i'm just getting round in circles getting variations of my final list..

    Thanks,

    Dan
    Attached Thumbnails Attached Thumbnails Dynamo List Sorting & Concatenating! I have the information, just wrong order! Help!!-circuits-script.jpg  

  4. #4
    Member
    Join Date
    May 30, 2015
    Posts
    200
    Current Local Time
    11:21 AM
    End of the day what you want is “circuit” + “list of spaces” + “comments”

    To do this you will need to first combine the “list” of spaces into a single value and then combine that with the circuit number and comments.

    Try grouping you list of space numbers by its circuit number, this should give you a list of the unique circuit numbers and a list of list containing the spaces. Each of the sub list you could then combine to a single value.

    Repeat the above with comments

    That should give you three equal list of equal length that you could then Combine to a single value.

    What this really means is you need to concat or combine your values multiple times to get to a single value.


    Sent from my iPhone using Tapatalk
    uaifestival and amoursol like this.

  5. #5
    New Member
    Join Date
    January 14, 2013
    Posts
    4
    Current Local Time
    04:21 PM
    Ok this is great! getting somewhere now!! thank you!

    i have my lists as you suggested (i think)...

    and now have a list of all the unique values that match the ones in the Revit schedule!



    now is there a way i can group together the rooms so the final string appears something like this..?

    L11 - R.06/R.07/R.08/R.09/R.10/R.11 SP
    L12 - R.02/R.03/R.04/R.05/R.12/R.13 SP
    L21 - R.06/R.07/R.09/R.10/R.11 CL
    L31 - R.02/R.03/R.05/R.12/R.13 CL

    instead of the 22 individual lines i have?
    Attached Thumbnails Attached Thumbnails Dynamo List Sorting & Concatenating! I have the information, just wrong order! Help!!-list-updated.jpg   Dynamo List Sorting & Concatenating! I have the information, just wrong order! Help!!-circuits-script-updated.jpg  

  6. #6
    New Member
    Join Date
    January 14, 2013
    Posts
    4
    Current Local Time
    04:21 PM
    Ok i managed to get the list to where i want it to be!

    i need to get this this to replace the values in this second list.

    i realise i can probably do this with a n export/ import from excel.

    but can it be done in dynamo without the excel step?

    i've tried a few nodes but all giving me errors.

    any thoughts on if i can do this, and how?



    Thanks,

    Dan
    Attached Thumbnails Attached Thumbnails Dynamo List Sorting & Concatenating! I have the information, just wrong order! Help!!-list-loads-parameter.jpg   Dynamo List Sorting & Concatenating! I have the information, just wrong order! Help!!-list-loads-parameter.jpg  

  7. #7
    Member
    Join Date
    May 30, 2015
    Posts
    200
    Current Local Time
    11:21 AM
    Quote Originally Posted by landofdan View Post
    Ok i managed to get the list to where i want it to be!

    i need to get this this to replace the values in this second list.

    i realise i can probably do this with a n export/ import from excel.

    but can it be done in dynamo without the excel step?

    i've tried a few nodes but all giving me errors.

    any thoughts on if i can do this, and how?



    Thanks,

    Dan
    If you are looking to put this value back into Revit, then use the Set Parameter by Name block and you should be all set


    Sent from my iPhone using Tapatalk
    amoursol likes this.

Similar Threads

  1. Sorting draw order for detail components with objects (families)
    By katewood1989 in forum Architecture and General Revit Questions
    Replies: 13
    Last Post: November 20th, 2017, 10:52 PM
  2. schedules and sorting information
    By mschirmer in forum Architecture - Family Creation
    Replies: 5
    Last Post: September 26th, 2017, 06:58 PM
  3. Property List Order Revit Family
    By MattKincaid in forum Architecture - Family Creation
    Replies: 3
    Last Post: February 10th, 2015, 05:19 PM
  4. Problem with toposurface tool connecting the elevation points in the wrong order.
    By simo8172 in forum Architecture and General Revit Questions
    Replies: 3
    Last Post: February 12th, 2014, 10:37 AM
  5. Replies: 0
    Last Post: January 20th, 2014, 04:16 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •