I have two CSV files which share one column called database in common. I am looking to merge both CSVs into one. Here is a summary of what I am looking for.
Database Size freespace
Database MBXCount WhiteSpace
Database Size freespace MBXCount WhiteSpace
Any help would be appreciated.
The PowerShell team made a blog post on this a couple years ago: [url="http://blogs.msdn.com/b/powershell/archive/2012/07/13/join-object.aspx"]Join-Object[/url]. As long as your set size is not too huge, it works great. (It doesn't scale well; very slow when you're trying to merge thousands of records.)
Thanks for the feedback. I actually went with merge-csv function. It did what I was looking for.
You must be logged in to reply to this topic.