#DateForumTypeThreadPost
306 Jun 2016 @ 02:50 PDTDatabaseReplyTranspose data from wide table to long tableDieter - Could you please explain the syntax that you used for TD_UNPIVOT ? BTW .. I see only these UDFs (TD_SYSFNLIB database - TDAMPCOPY, TD_Unpivot, CalcMatrix) are having TableKind as ...
226 Mar 2016 @ 05:05 PDTDatabaseReplyCOUNT () OVER (PARTITION BY) and DISTINCTThank you very much Dieter !!! Lakshminarasu
122 Mar 2016 @ 03:23 PDTDatabaseReplyCOUNT () OVER (PARTITION BY) and DISTINCTHi Dieter,  Just curious to know - if this is possible: I am in the same situation where I need to use DISTINCT in a OLAP function - but being not able to. COL_1 COL_2 COL_3 COL_4 COL_5 C...