<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>idea Allow JOINED schedules en Revit Ideas</title>
    <link>https://forums.autodesk.com/t5/revit-ideas/allow-joined-schedules/idi-p/7873408</link>
    <description>&lt;P&gt;In the world of relational databases there is the idea of a &lt;A href="https://en.wikipedia.org/wiki/Join_(SQL)" target="_blank"&gt;join&lt;/A&gt;. A join is a way to combine data from two distinct sets into a third set that contains some data from both. Both sets must contain a common filed that is used to join them together. Examples are a little hard to replicate here so I urge you to look at the &lt;A href="https://en.wikipedia.org/wiki/Join_(SQL)" target="_blank"&gt;Wikipedia entry for joins&lt;/A&gt;.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In Revit I find myself quite often wishing that I could create a schedule based on two other schedules that contain a common field. Consider this situation:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have a large multi-residential project where a number of host files, corresponding to different residential blocks, each contain links to standard apartment unit models. I have some schedules. Schedule A contains a list of all links in the host model. Each link has a unique name. Links that correspond to standard apartment units are named using a global apartment type naming convention.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Schedule B contains a list of all the rooms in the host model. Each room corresponds to a whole apartment. Each room has a&amp;nbsp;&lt;EM&gt;Name&lt;/EM&gt; property whose value is the apartment type (same as what's in Schedule A)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I want to, automatically, create a third schedule, C, that&amp;nbsp;&lt;EM&gt;joins&lt;/EM&gt; schedules A and B on the name property. That is, the resulting schedule will have rows with both the room and the corresponding link. I can then do counts of how many times a given unit is actually linked into the host file and used in my plans.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;As I write this I feel like my example is perhaps not the best but I believe that experienced BIM users will see its potential. I believe that this idea is sound and if implemented would provide a new and powerful way to query the model.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;cheers,&lt;/P&gt;&lt;P&gt;-tomek&lt;/P&gt;</description>
    <pubDate>Wed, 21 Mar 2018 22:04:09 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2018-03-21T22:04:09Z</dc:date>
    <item>
      <title>Allow JOINED schedules</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-joined-schedules/idi-p/7873408</link>
      <description>&lt;P&gt;In the world of relational databases there is the idea of a &lt;A href="https://en.wikipedia.org/wiki/Join_(SQL)" target="_blank"&gt;join&lt;/A&gt;. A join is a way to combine data from two distinct sets into a third set that contains some data from both. Both sets must contain a common filed that is used to join them together. Examples are a little hard to replicate here so I urge you to look at the &lt;A href="https://en.wikipedia.org/wiki/Join_(SQL)" target="_blank"&gt;Wikipedia entry for joins&lt;/A&gt;.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;In Revit I find myself quite often wishing that I could create a schedule based on two other schedules that contain a common field. Consider this situation:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have a large multi-residential project where a number of host files, corresponding to different residential blocks, each contain links to standard apartment unit models. I have some schedules. Schedule A contains a list of all links in the host model. Each link has a unique name. Links that correspond to standard apartment units are named using a global apartment type naming convention.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Schedule B contains a list of all the rooms in the host model. Each room corresponds to a whole apartment. Each room has a&amp;nbsp;&lt;EM&gt;Name&lt;/EM&gt; property whose value is the apartment type (same as what's in Schedule A)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I want to, automatically, create a third schedule, C, that&amp;nbsp;&lt;EM&gt;joins&lt;/EM&gt; schedules A and B on the name property. That is, the resulting schedule will have rows with both the room and the corresponding link. I can then do counts of how many times a given unit is actually linked into the host file and used in my plans.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;As I write this I feel like my example is perhaps not the best but I believe that experienced BIM users will see its potential. I believe that this idea is sound and if implemented would provide a new and powerful way to query the model.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;cheers,&lt;/P&gt;&lt;P&gt;-tomek&lt;/P&gt;</description>
      <pubDate>Wed, 21 Mar 2018 22:04:09 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-joined-schedules/idi-p/7873408</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2018-03-21T22:04:09Z</dc:date>
    </item>
    <item>
      <title>Re: Allow JOINED schedules</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-joined-schedules/idc-p/7874117#M19265</link>
      <description>&lt;P&gt;This would be great. Even more, it would finally help us make fast cost estimations: we could join a cost schedule for walls with a cost schedule for windows, and thus have a cost schedule for the whole building by adding the totals of the partial schedules.&lt;/P&gt;&lt;P&gt;Hope this attracts the attention from Autodesk!&lt;/P&gt;</description>
      <pubDate>Thu, 22 Mar 2018 07:54:00 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-joined-schedules/idc-p/7874117#M19265</guid>
      <dc:creator>peter_vanorshoven</dc:creator>
      <dc:date>2018-03-22T07:54:00Z</dc:date>
    </item>
    <item>
      <title>Re: Allow JOINED schedules</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-joined-schedules/idc-p/7882844#M19320</link>
      <description>&lt;P&gt;Yes, implement the often used database functionality in Revit.&amp;nbsp;&lt;/P&gt;&lt;P&gt;Another database related Ideas - &lt;A href="https://forums.autodesk.com/t5/revit-ideas/cross-tab-schedule/idi-p/7243901" target="_blank"&gt;Reports!&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 26 Mar 2018 04:06:46 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-joined-schedules/idc-p/7882844#M19320</guid>
      <dc:creator>Nurlan-A.</dc:creator>
      <dc:date>2018-03-26T04:06:46Z</dc:date>
    </item>
    <item>
      <title>Re: Allow JOINED schedules</title>
      <link>https://forums.autodesk.com/t5/revit-ideas/allow-joined-schedules/idc-p/9733520#M33630</link>
      <description>&lt;P&gt;Hi&amp;nbsp;@Anonymous&lt;/a&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If you wanna go with 3rd party plugins, BIMright has a feature called&amp;nbsp;&lt;STRONG&gt;Category Joins&lt;/STRONG&gt;, which is similar to your idea.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;A href="https://www.bimright.com/features/categoryJoin" target="_blank" rel="noopener"&gt;https://www.bimright.com/features/categoryJoin&lt;/A&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Mon, 07 Sep 2020 16:14:03 GMT</pubDate>
      <guid>https://forums.autodesk.com/t5/revit-ideas/allow-joined-schedules/idc-p/9733520#M33630</guid>
      <dc:creator>SamBerk</dc:creator>
      <dc:date>2020-09-07T16:14:03Z</dc:date>
    </item>
  </channel>
</rss>

