Change data type

[Parikhharshal]

Hi Talend experts

I have got below job design.

In this subjob Participation_Data creates the .csv file and puts into S3. And onsubjobok creates a table and then runs copy command to copy all S3 files into redshift table.

The csv file has all the columns in string. When I get the date field value from csv, it should ideally store field value in DATE type. I want to convert string to Date type. I know there is tconvertType/Tmap components to achieve this which can be added after copytoredshift component. But how do I add to make the design correct? 

Thanks

Harshal.

[Parikhharshal · Accepted solution]

Hi all

I did not know I could change the data type in tcreatetable component like this straight away.

Was simple one.