Here's a quick post that explains how to do something which may not be obvious.
The scenario: You've got some serialized data stored in a not-so-portable data interchange format (serialized PHP),
and would like the data to be made available as part of a PDI transformation.
Easy peasy lemon squeezy. Using the Javascript step, and the function found [here http://phpjs.org/functions/unserialize/].
Here's the transformation
Next we'll create a data grid to test it out.
This is the data in our grid.
This is our transformation script.
In the javascript step, right click at the top of the code pane and add a new script. Then click on it. Right-click on the tab for that script,
and select make start script. This will ensure that this code only gets executed once as opposed to once for every row (will make it faster).
You'll want to copy paste the javascript library linked above, and tweak it a little. First, change the function definition to resemble this screenshot:
And at the end, add a semi-colon.
Running the transform should produce something like this:
