https://community.qlik.com/t5/Talend-Studio/Change-data-type/m-p/2198080#M1557 <P>Hi Talend experts</P> <P>&nbsp;</P> <P>I have got below job design.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2018-11-30 at 1.06.00 pm.png" style="width: 945px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0oH.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140245iF45C744DD8D954F3/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0oH.png" alt="0683p000009M0oH.png" /></span></SPAN></P> <P>&nbsp;</P> <P>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.</P> <P>&nbsp;</P> <P>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.&nbsp;But how do I add to make the design correct?&nbsp;</P> <P>&nbsp;</P> <P>Thanks</P> <P>Harshal.</P> Sat, 16 Nov 2024 07:10:05 GMT Parikhharshal 2024-11-16T07:10:05Z https://community.qlik.com/t5/Talend-Studio/Change-data-type/m-p/2198080#M1557 <P>Hi Talend experts</P> <P>&nbsp;</P> <P>I have got below job design.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2018-11-30 at 1.06.00 pm.png" style="width: 945px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0oH.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/140245iF45C744DD8D954F3/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0oH.png" alt="0683p000009M0oH.png" /></span></SPAN></P> <P>&nbsp;</P> <P>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.</P> <P>&nbsp;</P> <P>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.&nbsp;But how do I add to make the design correct?&nbsp;</P> <P>&nbsp;</P> <P>Thanks</P> <P>Harshal.</P> Sat, 16 Nov 2024 07:10:05 GMT https://community.qlik.com/t5/Talend-Studio/Change-data-type/m-p/2198080#M1557 Parikhharshal 2024-11-16T07:10:05Z https://community.qlik.com/t5/Talend-Studio/Change-data-type/m-p/2198081#M1558 <P>Hi all</P> <P>&nbsp;</P> <P>I did not know I could change the data type in tcreatetable component like this straight away.</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screen Shot 2018-11-30 at 3.12.19 pm.png" style="width: 464px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M0Rf.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/137242i3D7324FEFFDC99CB/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M0Rf.png" alt="0683p000009M0Rf.png" /></span></SPAN></P> <P>&nbsp;</P> <P>Was simple one.</P> Fri, 30 Nov 2018 04:12:58 GMT https://community.qlik.com/t5/Talend-Studio/Change-data-type/m-p/2198081#M1558 Parikhharshal 2018-11-30T04:12:58Z