A short answer:
- Create a
CUSTOM.data
property on the table and bind that to the raw data source. - Create a Property Binding on the table's
PROPS.data
and point it to the custom property defined above. (Use the Browse Properties button to select it so that you don't goof up.) - Add a Script Transform to the
PROPS.data
property binding to manipulate your dataset as you want.
See how far you get with that and if you're in bother then post your script here. Please see Wiki - how to post code on this forum.