YES. SELECT FILENAME SAVING UNIQUE EVAL MFGNO:PARTNO or SELECT FILENAME SAVING UNIQUE EVAL MFGNO:"_":PARTNO
George >-----Original Message----- >From: Chauhan, Savita [mailto:[EMAIL PROTECTED] >Sent: Thursday, August 12, 2004 1:56 PM >To: [EMAIL PROTECTED] >Subject: RE: [U2] How do we get unique records from Universe >file(Table) > > >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/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
