Search code examples
pentahopentaho-spoonpentaho-data-integration

Import Date column in a particular format

I have an excel file which has a date column with different datatypes. For eg: few values have Date data-type while others have string format.

I tried to import the data and change the column metadata type to string but it changes the date values completely.

I have attached a few screenshots of the data, and I very new to Pentaho, so can anybody help me understand how to tackle this problem.

I tried changing the metadata type or using str2date function in js step but still, no use as data imported is different from the data from the file

enter image description here enter image description here

Solution

  • After changing the data type and importing the date values as string. Using SQL to store the date in string format and then formatting it while retrieving solved the issue.