This discussion is archived
0 Replies Latest reply: Jan 22, 2013 10:42 AM by 931546 RSS

Analytic Function

931546 Newbie
Currently Being Moderated
Hello, I need to create an analytic function, but I need some help because I am a newbie.

My table field contains dates and I need to count how many each of them exists. E.G. Date Num
15 Jan 2010 2
15 Jan 2010 2
23 May 2010 1

The new field Num will be stored in another table. I want to get back only the new field Num. Can someone give me the code for this?

What should I write in the RETURN line in the function?

I am working on Warehouse Builder and I will create the function there.

Your help would be very much essential to me. Thank you.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points