Im quite new to PowerShell, I have 4 piped scripts, each with their own select statements, then i have a select-object after the scriptblock that selects all columns previously selected from the different statements in the scriptblock, I then use Export-CSV to store the columns in an excel file. The problem is that the first select statement in the scriptblock returns 6 columns, the next select statement returns 1 column, the third select statement returns 2 columns and the last select statement returns 1 column. While the correct columns are returned, the exported excel csv file does not return all columns (specified again in the select-object statement after the scriptblock) in a single row, and instead increments by one row. How do I return all the columns into a single row?
Asked
Active
Viewed 32 times
