topic Re: Talend Enterprise 7.2.1 ( redshift) in Talend Studio

Talend Enterprise 7.2.1 ( redshift)

Anonymous — Wed, 13 Nov 2019 10:50:28 GMT

HI ,

I need to implement unpivot logic using tredshiftrow , is it possible to implement using tredshift row , I m developing job using tredshiftrow

I am looking for the component which is similar tOraclerow (from open source )

Ex:select * from monthly_sales
unpivot(sales for month in (jan, feb, mar, april))
order by empid;

manodwhb — Wed, 13 Nov 2019 12:41:19 GMT

@Moe , if you were creating standard jobs you can use tUnpivot component from talend exchange and you can install into your studio and use it.

Below link provide the details for version 7.1 of Talend but please note that its in deprecated state.

Anonymous — Wed, 13 Nov 2019 13:29:32 GMT

Thanks Manohar, but as I m creating big data batch job that option not there ,,, is there any other way ..kindly help

manodwhb — Thu, 14 Nov 2019 04:51:30 GMT

@Moe , need to see the data and can provide solution.