Is it possible to merge all players in a PT database into One?

castlevania · #1 05-31-2007, 02:14 PM

Is it possible to merge all players in a PT database into One? I'd like to do some queries on the average player. But I haven't figures out a way to merge all players. Is there a way?

NoChance · #2 05-31-2007, 02:34 PM

I've done something similar by Exporting the data into an excel spreadsheet and then doing my calculations there.

LouisCyphre · #3 05-31-2007, 04:21 PM

You could create thousands of aliases which is obviously a pain to do manually but maybe some script wizard can hook you up.

Tiki · #4 05-31-2007, 04:27 PM

Would an SQL query not be able to do this?

castlevania · #5 06-01-2007, 11:54 AM

[ QUOTE ]
You could create thousands of aliases which is obviously a pain to do manually but maybe some script wizard can hook you up.

[/ QUOTE ]

I tried this with an AHK script. But PT didn't allow me to merge players who had been at the same table together...

castlevania · #6 06-01-2007, 11:56 AM

[ QUOTE ]
I've done something similar by Exporting the data into an excel spreadsheet and then doing my calculations there.

[/ QUOTE ]

That sounds interesting. I'll think about how to execute that. But it feels like quite a work-around. Do you have any advice for a bloke about to give it a shot?

castlevania · #7 06-01-2007, 11:57 AM

[ QUOTE ]
Would an SQL query not be able to do this?

[/ QUOTE ]

I don't know. I'm not good with SQL. I've you have any tips on how to do this then please tell me!

Thanks to all of you!