Hello ;
I need a pivot table in my code. However I write this with sql , but I can not write in HANA My cod eis here:
--select temp2.*,PivotTable.hesap,("iscilik"/iweightsum)* case when COALESCE("U_isProdCostDist",'N')='N' then "iweight1" else 0 end*"sumquantity" as "isciliktoplam",("uretim"/iweightsum)* case when COALESCE("U_isProdCostDist",'N')='N' then "iweight1" else 0 end*"sumquantity" as "uretimtoplam",("fason"/iweightsum)* case when COALESCE("U_isProdCostDist",'N')='N' then "iweight1" else 0 end*"sumquantity" as "fasontoplam" from temp2, temphesap2 PIVOT (Max("tutar") FOR tip IN ("iscilik","uretim","fason")) AS PivotTable
Could you help me please ?