I am trying to import and merge columns from 2 CSV file into one using Powershell.
Please look at my code and advise.
I think that it is right, but I am not sure about referencing different columns from one cmdlet.
Import Data needed for Cap Report:
$columbs12 = Import-Csv \10.555.55.555\local\company\SUPPORT\REPOR\CAP - ShotName\Average-Action.csv | select -ExpandProperty UniqueRequests, UniqueUsers $columbs3456 = Import-Csv \\10.555.55.555\local\company\SUPPORT\REPOR\CAP - ShotName\Avg-per-Max-d.csv | select -ExpandProperty Percentile80, Percentile95, Percentile99, MaxDuration
Merge Files for Cap Report:
Merge-CSVFiles -CSVFiles $columbs12, $columbs3456 -OutputFile \\10.555.55.555\local\company\SUPPORT\REPOR\CAP - ShotName\CReport.csv