0

Creating an IMDB Time column in the Model designer

In the current version of Pyramid (2020.10), the Time type column is not supported when creating an IMDB model.

As a result, it will appear in a Discovery report but it will not be possible to filter by it.

This can be resolved using a Calculated column in the data flow.

Steps:

In the model, add the Calculated Column node to the canvas and connect it to the relevant Select node. then paste the below dateformat function in the script box on the right:

Time type:

dateformat([Column_name],"HH:mm:ss") 

*The time format in the above example can be changed if needed

*The calculated column type should be String.

Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 2 mths agoLast active
  • 22Views
  • 1 Following