https://community.qlik.com/t5/Talend-Studio/tRedshiftBulkExec-how-to-define-column-order/m-p/2264029#M44007 Hallo,<BR />is there a way to define the order of the columns when loading a csv from S3 to Redshift using tRedshiftBulkExec component?<BR />The Redshift command would be COPY (column1, column2 ...) FROM 's3://mybucket/mycsvfile.csv'. I would like to find in Talend the way to define (column1,column2...) Thu, 19 Jan 2017 09:48:40 GMT Anonymous 2017-01-19T09:48:40Z https://community.qlik.com/t5/Talend-Studio/tRedshiftBulkExec-how-to-define-column-order/m-p/2264029#M44007 Hallo,<BR />is there a way to define the order of the columns when loading a csv from S3 to Redshift using tRedshiftBulkExec component?<BR />The Redshift command would be COPY (column1, column2 ...) FROM 's3://mybucket/mycsvfile.csv'. I would like to find in Talend the way to define (column1,column2...) Thu, 19 Jan 2017 09:48:40 GMT https://community.qlik.com/t5/Talend-Studio/tRedshiftBulkExec-how-to-define-column-order/m-p/2264029#M44007 Anonymous 2017-01-19T09:48:40Z https://community.qlik.com/t5/Talend-Studio/tRedshiftBulkExec-how-to-define-column-order/m-p/2264030#M44008 Hi, <BR />Could you please take a look at settings for "Parameter" and "Value" in advanced setting of&nbsp; <FONT size="1"><FONT face="Verdana, Helvetica, Arial, sans-serif">tRedshiftBulkExec component? Which can be used to&nbsp;</FONT></FONT> <FONT size="2"><FONT face="noto, Helvetica, Arial, sans-serif">specify more parameters for loading the data.</FONT></FONT> <BR /> <FONT size="2"><FONT face="noto, Helvetica, Arial, sans-serif">For more information, please refer to doc:<A href="http://docs.aws.amazon.com/redshift/latest/dg/r_COPY.html" target="_blank" rel="nofollow noopener noreferrer">http://docs.aws.amazon.com/redshift/latest/dg/r_COPY.html</A></FONT></FONT> <BR />Best regards <BR />Sabrina Mon, 13 Feb 2017 07:03:31 GMT https://community.qlik.com/t5/Talend-Studio/tRedshiftBulkExec-how-to-define-column-order/m-p/2264030#M44008 Anonymous 2017-02-13T07:03:31Z