Automation script
Ever needed to apply an expression to huge amount of input ports? Here's a quick view of a helpful script that simplifies this task. On the movie you can see adding trimming and changing NULLs to N/A applied to 17 input ports. Imagine having 160 of them :)
How does it work? Here's a sample video.
2011.03.19 UPDATE: Below you'll find the new, even simpler to use version: from now on using "copy-paste" macro does not require any parameters. Here's what you need to do:
- open any PC transformation you'd like to edit
- set focus on port to begin with (up to this point it's just the same as shown on video above)
- click the first cell in excel with prepared values
- click the "Copy_Paste" button - that's all!
The script starts with highlighted cell and moves down until it finds an empty cell.
2011.07.25 UPDATE: New version available - in 1.2 you'll find new features and easy to use "safe-mode" that solves the problem of filling just the first row of transformation on some configurations.
All versions are available for download below: