Can this (selecting only those order IDs which have unique combination of Mfg.No and Part.No) be done "without" having to create an intermediate dictionary item?
Savita Chauhan, Programmer/Analyst x:1754 Central Texas College. ------------------------------------------- Change is the only Constant. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: Thursday, August 12, 2004 10:31 AM To: [EMAIL PROTECTED] Subject: RE: [U2] How do we get unique records from Universe file(Table) 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/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
