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 Eric@saltydogllc.com 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 Paul.Newton@pegasus.co.uk 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]