Talend Enterprise 7.2.1 ( redshift)

Anonymous · ‎2019-11-13

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 · ‎2019-11-13

@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 · ‎2019-11-13

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

manodwhb · ‎2019-11-13

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