You can setup a DICTIONARY ITEM that concatantes both values
IE.
ED DICT FILE MFGPARTNO
MFGPARTNO
001: I
002: MFG.NO:PART.NO
003:
004: combo
005: 20L
006: S
Assuming they are both single valued fields:
Then
SELECT ORDERS SAVING UNIQUE MFGPARTNO
George
>-----Original Message-----
>From: Chauhan, Savita [mailto:[EMAIL PROTECTED]
>Sent: Thursday, August 12, 2004 11:09 AM
>To: [EMAIL PROTECTED]
>Subject: RE: [U2] How do we get unique records from Universe
>file(Table)
>
>
>Can we save a unique combination of more than one fields, instead of
>just saving the unique @ID
>ie,
>
>>SELECT ORDERS SAVING UNIQUE MFG.NO PART.NO
>
>Will this save records with unique combination of mfg.no and part.no?
>
>
>Savita.
>
>
>-----Original Message-----
>From: [EMAIL PROTECTED]
>[mailto:[EMAIL PROTECTED] On Behalf Of Pingilley, Ron
>Sent: Thursday, August 12, 2004 9:46 AM
>To: '[EMAIL PROTECTED]'
>Subject: RE: [U2] How do we get unique records from Universe
>file(Table)
>
>"tax in advance" -- sounds like the US Government! :)
>
>If you're doing a SELECT at tcl, try adding SAVING UNIQUE to your
>statement.
>Here's an example:
>
>> SELECT ORDERS WITH ORDER.DATE > "8/1" PART.NUMBER
>
>...10456 items selected
>
>>> SELECT INVENTORY SAVING UNIQUE @ID
>
>...395 items selected
>
>>> SAVE.LIST AUG.PARTS
>
>1st step selected the PART.NUMBER field from the ORDERS file, with lots
>of
>duplicate part numbers showing up. The 2nd step pared that
>list down to
>just unique part numbers.
>
>--Ron P.
>
>-----Original Message-----
>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Thursday, August 12, 2004 9:05 AM
>To: [EMAIL PROTECTED]
>Subject: [U2] How do we get unique records from Universe file(Table)
>
>
>Hi,
>
>Can anybody help me in retriving the unique(distinct) records from
>Universe file
>
>tax in advance
>
>regards
>Reddy
>-------
>u2-users mailing list
>[EMAIL PROTECTED]
>To unsubscribe please visit http://listserver.u2ug.org/
>-------
>u2-users mailing list
>[EMAIL PROTECTED]
>To unsubscribe please visit http://listserver.u2ug.org/
>-------
>u2-users mailing list
>[EMAIL PROTECTED]
>To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[EMAIL PROTECTED]
To unsubscribe please visit http://listserver.u2ug.org/
