<div>
That was exactly what I needed. Thanks!
</div>


<div>
Wow, that's cool, so the hash table can be used just like SQL table to join the two table based on certain criteria ?
</div>


<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I am looking for a script to do the following :<br />
<br />
<br />
CSV1<br />
Server, IP address, Role, Address, Reboot Policy<br />
<br />
CSV2<br />
Server, Chassis Address, management IP,<br />
<br />
I would like the final CSV to have the following Columns and rows<br />
CSV3<br />
Server, IP Address, Chassis, Management Address, Reboot Policy, Role<br />
<br />
I would like to Merge the two CSV's using the server field from CSV2.<br />
<br />
This is a little above my scripting level at the moment.
</div>
</div>


Experts,

I am looking for a script to do the following :


CSV1
Server, IP address, Role, Address, Reboot Policy

CSV2
Server, Chassis Address, management IP,

I would like the final CSV to have the following Columns and rows
CSV3
Server, IP Address, Chassis, Management Address, Reboot Policy, Role

I would like to Merge the two CSV's using the server field from CSV2.

This is a little above my scripting level at the moment.

Powershell Excel Script

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

A scripting language is a programming language that supports scripts, programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator. Scripting languages are often interpreted (rather than compiled). Primitives are usually the elementary tasks or API calls, and the language allows them to be combined into more complex programs. Environments that can be automated through scripting include software applications, web pages within a web browser, the shells of operating systems (OS), embedded systems, as well as numerous games. A scripting language can be viewed as a domain-specific language for a particular environment; in the case of scripting an application, this is also known as an extension language.

Scripting Languages

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.