| Title: | FOCUS, from INFORMATION BUILDERS |
| Moderator: | ZAYIUS::BROUILLETTE |
| Created: | Thu Feb 19 1987 |
| Last Modified: | Mon May 05 1997 |
| Last Successful Update: | Fri Jun 06 1997 |
| Number of topics: | 615 |
| Total number of notes: | 1779 |
<<< RUNTUF::SYSB$:[NOTES$LIBRARY]IBI_FOCUS.NOTE;2 >>>
-< FOCUS, from INFORMATION BUILDERS >-
================================================================================
Note 592.9 Need list of users for FOCUS phase-out strategy 9 of 9
UBOHUB::FARRANTL "Lee Farrant" 29 lines 4-JAN-1995 22:30
-< Multiple records/excluding? >-
--------------------------------------------------------------------------------
Hello , I wonder if someone can help me with multiple records.
I have multiple records as below but would like to exclude
all mutliple versions of the record if for example '2nd field'
is equal to NORTHUK_P1.
At the moment I only know how to exclude the record which contains
the data I am looking for (NORTHUK_P1) and not exclude the related
duplicate record which does not?
1st field 2nd field 3rd field
979230049Q1UVO NORTHUK_P1 199412
979280049Q1UVO SUK_SPA 199412
979390049Q1UVO NORTHUK_P1 199412
979390049Q1UVO SUK_SPA 199412
979390049Q1UVO SUK_SPA 199412
979540049Q1UVO SOUTHUK_P1 199412
979540049Q1UVO SOUTHUK_P1 199412
980750049Q1UVO SOUTHUK_P1 199412
980930049Q1UVO L63_DTS 199412
Lee
| T.R | Title | User | Personal Name | Date | Lines |
|---|---|---|---|---|---|
| 597.1 | need a clearer output example | BRAT::WEHIKE::Clark | Mon Jan 09 1995 13:47 | 20 | |
You need to give a clearer example of the output you want. I had typed a 20 line request, but this pc lost it. So, this is briefer. for the lines north south south what do you want to remain ?? for south east east what do you want ? etc give me a call or send mail, if you wish dtn 264-8010 Debi | |||||
| 597.2 | Another question. | UBOHUB::FARRANTL | Lee Farrant | Thu Apr 06 1995 05:55 | 43 |
Hello all, me again,
I have created for example two little tables using count and columns.
I have joined them both together with VMS append.
But because I have only used REQU_SD_UNIT in the column command
the final table will not allow be to use the field as it does not
recognise it. I'd like the 3rd and final table to present the
information in the first two .ftm files across REQU_SD_UNIT like the
first two?
DEFINE FILE REQUST_O
LINE/A2='01';
END
TABLE FILE REQUST_O
COUNT REQU_LOG_NO ACROSS REQU_SD_UNIT COLUMNS 'H46 S1' AND 'H46 T1' AND
'L63 SW' AND 'L63 NE'
BY LINE
IF REQU_SD_UNIT EQ 'H46 S1' OR 'H46 T1' OR 'L63 SW' OR 'L63 NE'
IF RECORDLIMIT EQ 30
ON TABLE HOLD AS LINE1
END
-RUN
DEFINE FILE REQUST_O
LINE/A2='02';
END
COUNT REQU_LOG_NO ACROSS REQU_SD_UNIT COLUMNS 'H46 S1' AND 'H46 T1' AND
'L63 SW' AND 'L63 NE'
BY LINE
IF REQU_SD_UNIT EQ 'H46 S1' OR 'H46 T1' OR 'L63 SW' OR 'L63 NE'
IF RECORDLIMIT EQ 30
ON TABLE HOLD AS LINE2
END
-RUN
-VMS APPEND LINE1.FTM LINE2.FTM
TABLE FILE LINE2
......(BOTH TOGETHER) BY LINE across REQU_SD_UNIT?
Lee
| |||||
| 597.3 | UBOHUB::FARRANTL | Lee Farrant | Mon Apr 10 1995 04:24 | 6 | |
Moderator
I have sorted this out, you can delete it if you want
Lee
| |||||