Ah the good ol' days. Still great content.
Too bad M$ didn't keep the Fox going. What a great tool....still to
this day.
On 5/21/2019 1:44 PM, Ted Roche wrote:
(Replying to Eric because I never see Paul's original posts)
July 2006 Advisor Answers:
http://www.tomorrowssolutionsllc.com/Articles/Create%20Cross-tabs.PDF
and the FoxWiki Tamar references:
http://fox.wikis.com/wc.dll?Wiki~CrossTab~VB
http://fox.wikis.com/wc.dll?Wiki~MatXTab (with download link)
On Tue, May 21, 2019 at 10:28 AM Eric Selje <[email protected]> wrote:
There's a cross-tab wizard that comes with VFP, but I'd look at this VFPX
project: https://github.com/VFPX/FastXTab
Eric
On Tue, May 21, 2019 at 8:43 AM Paul Newton <[email protected]>
wrote:
Hi all
I have data like this:
Tablename Auditdate Auditsize
CTRAN 01/01/2019 25
PTRAN 01/01/2019 30
STRAN 01/01/2019 35
CTRAN 01/02/2019 30
PTRAN 01/02/2019 35
STRAN 01/02/2019 40
CTRAN 01/03/2019 35
PTRAN 01/03/2019 40
STRAN 01/03/2019 45
And I want to process it in such a way that it ends up like this
TableName 01/01/2019 01/02/2019 01/03/2019
CTRAN 25 30 35
PTRAN 30 35 40
STRAN 35 40 45
I realise that the dates would have be converted to valid field names.
Anybody have ideas/suggestions? Does anybody know of a tool that would
achieve this?
Many thanks
Paul Newton
[excessive quoting removed by server]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: https://leafe.com/archives
This message:
https://leafe.com/archives/byMID/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
