I am attempting to use the pre-built JavaScript Transformation for "Split Column Transformation" and cannot get it to run without an error about a column I'm not even using.
I'm doing the following:
- Once I've added the component to the Dataflow, I then connect it to the previous step (Rest Destination).
- Double Click on the component to choose what script I want to use.
- I've selected the Split Column Transformation and click Ok
- In the next window I supply the column (OrderRecords) from the previous step and the delimiter (", ")
- I then click okay.
- I believe I next have to go to the Advanced Editor to select the desired Input Column (OrderRecords) and then create a Output Column (Orders). I gave the column a name and set the datatype to DT_WSTR
- Then try running the debug for the dataflow. I get the following error:
- [JavaScript Component [524]] Error: Jurassic.JavaScriptException: Error: The column with name "Id" does not exist.
There is an "Id" column in the output of the previous step but I'm not trying to use it in the JavaScript component and it's not checked in the "Advanced Editor" > "Input Columns". It is the first one listed though in this window.
Am I missing something? If so what? Thanks for any pointers