Jump to content
We've recently updated our Privacy Statement, available here. ×

Data Function / Converting Cross Table to Data Table


Anonymous Man

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...