Thanks for the help guys

Got it working using the script component and Phil's suggestion of using a local variable

Thanks for the feedback guys

I have tried implementing a script component to transform the data  but am g now getting the following error messages

The collection of...