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
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]
Thanks Eric
I seem to recall FastXTab from way, way back. I'll take another look at it
Paul Newton
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Eric Selje Sent: 21 May 2019 15:28 To: profoxtech@leafe.com Subject: Re: ? Cross tabulation
Sent by an external sender ------------------------------
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]
(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]
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]
Many thanks Ted for those very helpful pointers. In fact I went with FastXTab and had the result I wanted in just a few minutes.
Paul Newton
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Ted Roche Sent: 21 May 2019 18:45 To: profoxtech@leafe.com Cc: profoxtech@leafe.com Subject: Re: ? Cross tabulation
Sent by an external sender ------------------------------
(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]
-
Eric Selje -
MB Software Solutions, LLC -
Paul Newton -
Ted Roche