Data Function / Converting Cross Table to Data Table

[Anonymous Man]

I have a list of dates which represents an event occurence - example below.

01/01/2001

02/02/2002

02/02/2002

03/03/2003

03/03/2003

03/03/2003

I'd like to create a new data table for the purposes of regression modellingwith the layout.

Dates Count

01/01/2001 1

02/02/2002 2

03/03/2003 3

I understand that I can create a cross table, export it as CSV and re-import it as a new data table which is time consuming.

I have found a script to convert a cross table into a data table, however I will not have access to the clr library any time soon.

I've created data function which creates a data table but with only a list of unique dates - not too sure what the next steps would be.

output

[Dylan Novakowski]

Insert > Transformation

'Pivot'

Row Identifiers: [Date]

Values(%V) and aggregation methods (%M): Count([Date])

Column Naming Pattern: %M(%V)

 

This will replace the old data table with the desired one.