I’d like to do a Powershell Transformation using multiple columns. The only option for specifying Input to Powershell is a single column. Is the recommended way to concatenate multiple values into a single column? It would be nice to be able to specify multiple columns or the entire table in the future.
Sidebar - the powershell transformation seems very powerful and is quite fast in my early testing. Thank you for adding it
Yes, at this point the only option for multiple columns is concatenating them into one before sending to PowerShell. Here is a sequence of transformations that concatenates all columns in a table into one column:
It's a derived table. Just point it to a table which columns need to be concatenated.
I'm curious what statement do you use in PowerShell to split a row back into separate values? How do you deal with values that contain line breaks (if it happens)?
You're welcome! The PowerShell transformation appeared to a big extent due to your suggestions on the forum.
We decided to add full table input for PowerShell in v3.8. The table will be provided as a sequence of arrays, where each array is 1 table row.
There are some ideas for capturing output too. Two new modes are possible:
Capturing object properties by name. In this mode the user specifies in the transformation the names of object properties to capture. Each property captured into a column named after it.
Capturing a jagged array (array of arrays). This is basically the same format as for the full table input.