[focus-l] Re: TRUNCATION
- From: "Hamilton, Robert" <roberth@xxxxxxxxxxxx>
- To: <focus-l@xxxxxxxxxxxxx>
- Date: Wed, 5 May 2004 13:25:20 -0500
COUNT ME IN as old-school; saw my first computer in xmas break in 1950
at
The IBM service bureau.
I now have this thing down to two files; file A can have more than one
row per ssn; FILE B has only one row per ssn. I need to join them so
that each and every row in A has its' corresponding info from B. Many
times I've tried
This with JOIN with remarkable lack of success. Also match seems to
work
Sometimes in this situation.
Any suggestions?
bobh
-----Original Message-----
From: focus-l-bounce@xxxxxxxxxxxxx [mailto:focus-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Mickey Grackin
Sent: Wednesday, May 05, 2004 1:13 PM
To: focus-l@xxxxxxxxxxxxx
Subject: [focus-l] Re: TRUNCATION
Robert,
You may also use the SET BYDISPLAY =3D ON. This forces FOCUS to show =
the
value of the BY phrases on each row. I think this was mainly added for
Excel but it works for all output formats. This was added in WebFOCUS
4.3.6(?) I think.
Harry's way will also work. That's the old school way of accomplishing
the
same result. No insult intended. :)
Mickey Grackin
(301) 975-8417
-----Original Message-----
From: focus-l-bounce@xxxxxxxxxxxxx
[mailto:focus-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Harry Wykes
Sent: Wednesday, May 05, 2004 2:00 PM
To: focus-l@xxxxxxxxxxxxx
Subject: [focus-l] Re: TRUNCATION
Robert,
>> Another thing; is there a way to make focus list every value in each
row
it Is very confusing for the user to see
STU_ID FUND EFC OFFER_BAL ROW AMT1 cOL1 HOUSING
------ ---- --- --------- --- ---- ---- -------
xxx263738 84604 0 7029.00 1 0 XFUND
xxx267177 80014 0 1519.00 1 1519 2
<snip>
I need to get stu_id to appear in each and every row and have never
Figured out how to do it . . .
<<
Try
PRINT STU_ID FUND EFC OFFER_BAL ROW AMT1 cOL1 HOUSING
BY STU_ID NOPRINT BY FUND NOPRINT etc.
Harry Wykes, UK
Other related posts:
