What uniquery syntax will roll up the third column into an unduped list for each unduped item in the second column, all while suppressing display of the first column.
Note that the second column also contains values such as L2, L3, etc.
What uniquery syntax will roll up the third column into an unduped list for each unduped item in the second column, all while suppressing display of the first column.
Note that the second column also contains values such as L2, L3, etc.
You could try this, but I suspect it may not be totally what you want, but does provide the result you asked for
list SWALDIE BY A1 BY A2 A1 A2 09:53:50 17 Sep 2024 1SWALDIE... Col 1..... Col 2.....
1 L1 OP12 L1 OP13 L1 OP14 L1 REP15 L1 S16 L1 S17 L1 S18 L2 S19 L2 S19 records listed
list SWALDIE BY A1 BY A2 BREAK-ON A1 BREAK-ON A2 ID.SUP DET.SUP 09:55:17 17 Sep2024 1Col 1..... Col 2.....
OP1 REP1 S1L1 S1L29 records listed
What uniquery syntax will roll up the third column into an unduped list for each unduped item in the second column, all while suppressing display of the first column.
Note that the second column also contains values such as L2, L3, etc.
Another way to get the format as you want is to use REFORMAT to send the information to another work file and list that.
:AE DICT SWALDIE A1 A2 A1A2< 1 > Top of "A1" in "DICT SWALDIE", 6 lines, 16 characters.001: D002: 1003:004: Col 1005: 10L006: SBottom.*--: EXQuit "A1" in file "DICT SWALDIE" unchanged.< 2 > Top of "A2" in "DICT SWALDIE", 6 lines, 16 characters.001: D002: 2003:004: Col 2005: 10L006: SBottom.*--: EXQuit "A2" in file "DICT SWALDIE" unchanged.< 3 > Top of "A1A2" in "DICT SWALDIE", 6 lines, 36 characters.001: I002: N(A1) : "*" : N(A2)003:004: New Key005: 10L006: SBottom.*--: EXQuit "A1A2" in file "DICT SWALDIE" unchanged.:
:CLEAR.FILE DATRA SWALDIE.TEMP
:REFORMAT SWALDIE A1A2File name : SWALDIE.TEMP
:LIST SWALDIE.TEMP BY EVAL 'FIELD(@ID,"*",1)' BY EVAL 'FIELD(@ID,"*",1)' EVAL 'FIELD(@ID,"*",1)' COL.HDG "A1" EVAL 'FIELD(@ID,"*",2)' COL.HDG "A2" ID.SUP
LIST SWALDIE.TEMP BY EVAL 'FIELD(@ID,"*",1)' BY EVAL 'FIELD(@ID,"*",1)' EVAL 'FIELD(@ID,"*",1)' COL.HDG "A1" EVAL 'FIELD(@ID,"*",2)' COL.HDG "A2" ID.SUP 12:03:48 17 Sep 2024 1A1........ A2........
L1 OP1L1 REP1L1 S1L2 S14 records listed
What uniquery syntax will roll up the third column into an unduped list for each unduped item in the second column, all while suppressing display of the first column.
Note that the second column also contains values such as L2, L3, etc.
Jonathan is of course right in the BREAK.ON, but that is going to give you two levels of break, which may or may not be what you want. If you are really looking to get a list of the unduped combinations of those two columns, you could combine both into an expression and break on that combination.
LIST SWALDIE BY A1 BY A2 BREAK.ON EVAL "A1:' ':A2" FMT "20L" DET.SUP ID.SUP 12:24:56 Sep 17 2024 1
A1:' ':A2
L1 OP1
L1 REP1
L1 S1
L2 S1
9 records listed
Again, may or may not give you exactly what you want...
You could try this, but I suspect it may not be totally what you want, but does provide the result you asked for
list SWALDIE BY A1 BY A2 A1 A2 09:53:50 17 Sep 2024 1SWALDIE... Col 1..... Col 2.....
1 L1 OP12 L1 OP13 L1 OP14 L1 REP15 L1 S16 L1 S17 L1 S18 L2 S19 L2 S19 records listed
list SWALDIE BY A1 BY A2 BREAK-ON A1 BREAK-ON A2 ID.SUP DET.SUP 09:55:17 17 Sep2024 1Col 1..... Col 2.....
OP1 REP1 S1L1 S1L29 records listed
Thank you @Jonathan Smith
This worked for my purposes.
Jonathan is of course right in the BREAK.ON, but that is going to give you two levels of break, which may or may not be what you want. If you are really looking to get a list of the unduped combinations of those two columns, you could combine both into an expression and break on that combination.
LIST SWALDIE BY A1 BY A2 BREAK.ON EVAL "A1:' ':A2" FMT "20L" DET.SUP ID.SUP 12:24:56 Sep 17 2024 1
A1:' ':A2
L1 OP1
L1 REP1
L1 S1
L2 S1
9 records listed
Again, may or may not give you exactly what you want...
Very clever, @Brian Leach.
Thank you.
What uniquery syntax will roll up the third column into an unduped list for each unduped item in the second column, all while suppressing display of the first column.
Note that the second column also contains values such as L2, L3, etc.
You also have the SAVING UNIQUE query clause.
SELECT File SAVING UNIQUE Field1 SAVING UNIQUE Field2.
GET.LIST
LIST FILE Field1 Field2.
UniData only supports one SAVING clause in a query, so that would need an I-Descriptor for 'Field1 : "*" : Field2', and then SAVING UNIQUE on the I-Descriptor field. The select list then contains the paired values of interest.
What uniquery syntax will roll up the third column into an unduped list for each unduped item in the second column, all while suppressing display of the first column.
Note that the second column also contains values such as L2, L3, etc.
You could also use a SQL query like this:
SELECT DISTINCT A1, A2 FROM SWALDIE;
The semicolon at the end is important.
You also have the SAVING UNIQUE query clause.
SELECT File SAVING UNIQUE Field1 SAVING UNIQUE Field2.
GET.LIST
LIST FILE Field1 Field2.
UniData only supports one SAVING clause in a query, so that would need an I-Descriptor for 'Field1 : "*" : Field2', and then SAVING UNIQUE on the I-Descriptor field. The select list then contains the paired values of interest.
Thank you, @Mark Baldridge.
I had actually tried this one already, but it didn't provide quite enough visual separation between values to make it beneficial for me.
You could also use a SQL query like this:
SELECT DISTINCT A1, A2 FROM SWALDIE;
The semicolon at the end is important.
Thank you, @Charlie Corbett.
Do the files have to be vsg'd to run sql queries against them? I wouldn't be able to use this if so.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
