I'm looking for the same thing.
There are no example on TPT's typical use.
Is there someone who can give us an example which illustrate the use of TPT in a typical project ? Producer, Consomer and transform data.
I've found an very interesting explanation and example on TPT with this website but you have to pay for that :
Please look at the TPT Reference and/or User Guide at the syntax for the CASE statement support.
I think you will be able to see how this is possible in the TPT script language.