<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://blogs.msdn.com/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Join-Object</title><link>http://blogs.msdn.com/b/powershell/archive/2012/07/13/join-object.aspx</link><description>Problem: 
 How do I join two lists of objects into a single list? Or the equivalent: How do I join two CSV files into a single one? 
 Note that joining makes sense only when the two lists or CSV files have something in common. 
 
 Why do we need Join</description><dc:language>en-US</dc:language><generator>Telligent Evolution Platform Developer Build (Build: 5.6.50428.7875)</generator><item><title>re: Join-Object</title><link>http://blogs.msdn.com/b/powershell/archive/2012/07/13/join-object.aspx#10386333</link><pubDate>Fri, 18 Jan 2013 17:51:42 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10386333</guid><dc:creator>Sunos</dc:creator><description>&lt;p&gt;Mark!&lt;/p&gt;
&lt;p&gt;This section is very useful to me.&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10386333" width="1" height="1"&gt;</description></item><item><title>re: Join-Object</title><link>http://blogs.msdn.com/b/powershell/archive/2012/07/13/join-object.aspx#10379427</link><pubDate>Wed, 19 Dec 2012 14:03:56 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10379427</guid><dc:creator>Raimund Andrée</dc:creator><description>&lt;p&gt;Excellent stuff. This is part of my workshop content now...&lt;/p&gt;
&lt;p&gt;Thanks,&lt;/p&gt;
&lt;p&gt;Raimund&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10379427" width="1" height="1"&gt;</description></item><item><title>re: Join-Object</title><link>http://blogs.msdn.com/b/powershell/archive/2012/07/13/join-object.aspx#10355782</link><pubDate>Thu, 04 Oct 2012 05:34:41 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10355782</guid><dc:creator>Stephen Mills</dc:creator><description>&lt;p&gt;Thanks for putting this out here. &amp;nbsp;This is really a needed function for PowerShell and it is to bad it wasn&amp;#39;t included in V3. &amp;nbsp;There is one change I would suggest with it though. &amp;nbsp;I seems to make sense for the most part except for the Where parameter. &amp;nbsp;When you call the function you have a Left and Right parameter, but in the Where clause you reference those with $args[0] and $args[1]. &amp;nbsp;&lt;/p&gt;
&lt;p&gt;So a where clause looks like:&lt;/p&gt;
&lt;p&gt;-Where { $args[0].Id -eq $args[1].EmployeeId }&lt;/p&gt;
&lt;p&gt;It would be nicer if it were to use $Left and $Right. &amp;nbsp;Then it would be easier to understand. &amp;nbsp;It shouldn&amp;#39;t be too hard to do if you just recreate the Where scriptblock inside your function with something like the following.&lt;/p&gt;
&lt;p&gt;$NewWhere = $ExecutionContext.InvokeCommand.NewScriptBlock( &amp;#39;param ( $Left, $Right)&amp;#39; + $Where.ToString())&lt;/p&gt;
&lt;p&gt;Then the Where parameter would be used like:&lt;/p&gt;
&lt;p&gt;-Where { $Left.Id -eq $Right.EmployeeId }&lt;/p&gt;
&lt;p&gt;This would be more intuitive than it currently is, although I could see some benifit if the parameters were $LeftItem and $RightItem, but I prefer it to have the same name as the parameters used in the function even if there is some room for confusion ( one is a collection and one is a single item).&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10355782" width="1" height="1"&gt;</description></item><item><title>re: Join-Object</title><link>http://blogs.msdn.com/b/powershell/archive/2012/07/13/join-object.aspx#10333931</link><pubDate>Thu, 26 Jul 2012 22:06:18 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10333931</guid><dc:creator>PowerShell Team</dc:creator><description>&lt;p&gt; updated the script part of this blog today (7/26/2012) to support the hashtable syntax for the Property parameter of Join-Object. Please see the property documentation for details. &lt;/p&gt;
&lt;p&gt;Regarding Jeremy&amp;#39;s question: Join-Object will not be in the default PS 3.0 package.&lt;/p&gt;
&lt;p&gt;Lucio Silveira [MSFT]&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10333931" width="1" height="1"&gt;</description></item><item><title>re: Join-Object</title><link>http://blogs.msdn.com/b/powershell/archive/2012/07/13/join-object.aspx#10330237</link><pubDate>Mon, 16 Jul 2012 17:26:22 GMT</pubDate><guid isPermaLink="false">91d46819-8472-40ad-a661-2c78acb4018c:10330237</guid><dc:creator>Jeremy Engel</dc:creator><description>&lt;p&gt;Great function! I added it to my default modules list. Do you think will get included with the default PS 3.0 package?&lt;/p&gt;
&lt;div style="clear:both;"&gt;&lt;/div&gt;&lt;img src="http://blogs.msdn.com/aggbug.aspx?PostID=10330237" width="1" height="1"&gt;</description></item></channel></rss>