In a tranformation, I have a field that is milliseconds epoch time. How does one take this field and convert it to a Date field with the correct value?
You can use a Select Values step and it should work. Feed your stream that contains the UNIX time field into a Select Values step and in the Meta-data tab of the Select Values step, add the UNIX time field and change the Type to Date and select whatever format you'd prefer.
If you find that doesn't work for whatever reason, you should be able to use a Modified Java Script Value step with the below code (where 'unixtime' would be your incoming field and 'regulartime' would be your outgoing field)
var regulartime = new Date(unixtime)
Using Date Conversion stage
This is for Pentaho Data Integration via Spoon, not HCI. I wasn't able to locate something similar in Spoon. Hopefully this went to the right community. :-)
Retrieving data ...