I’m not sure if I am fully understanding what you are looking for but I think I might - do you mean that you want individual Excel sheets for each schedule, and each sheet has a column populated with the shared parameters that are in the schedule?
I was thinking thats what he meant but I was not sure. If it is I think the unique keys can be plugged in for Sheet name and groups into data and it should work.
If it all should be in one sheet then what I have above should do it. Might need to be transposed (I always get that mixed up).
@Steven Group by Key wouldn’t work because right now the graph that @ksuszko2005 is showing is just creating a list of the schedules and a list of the shared parameters in the document.
If the goal is to get lists of the Shared Parameters in each schedule one would need to:
Collect Schedule Views and Collect Shared Parameter Elements
Get the names of the Schedule fields in each schedule and turn into string
Find occurrences of schedule field names in names of Shared Parameter Elements
This is exactly what I was looking for. Thank you! I apologize for my lack of reference photos and correct terminology. I attempted to post multiple photos (including an excel sheet of what I wanted) and since I’m a “new member” I could not.
Actually… I was a tad too optimistic. I have tried the code several times and I haven’t been able to get it to work. It does load excel sheets for all of my schedules, but each of the sheets are blank. I need to get the schedule name in one column, and the shared parameters in that schedule in another column. (or have the first row being the schedule name). For example, I have 96 schedules in a blank project (almost like a template), each with a name and several shared parameters. The schedule names are listed under “View Name” in Identity Data. I’m having trouble understanding how to filter each schedule to show the shared parameters in only that schedule.
The HEATING & VENTILATION UNIT SCHEDULE- 238223-1 is the view name of the schedule, and the "Heat & Vent Unit- " are the shared parameters in the schedule. I don’t want their data, only their names for quality control.
The graph I shared with you should populate each sheet (per schedule) with the shared parameters belonging to that schedule, and the schedule name would be the header rather than in a separate column like you desire - I didn’t test out making it one column with the schedule name and the other with that schedule’s shared parameters, but either way, if you ran the graph and your excel doc was empty, it sounds like either your schedules do not have shared parameters or something in your graph didn’t work right, could you upload a screen capture of the graph you ran?
Ok so I’ve been playing around some more, and it seems like the “If Equal Return Index” is the issue. Am I using the wrong node? What should I do to “update” it? I have all of my schedules and their shared parameters and all of the shared parameters. Thanks so much for the help!
