How can we make the fields unique in Query Manager in PeopleSoft ?
Asked
Active
Viewed 263 times
-2
-
Questions on how to operate computer programs are off-topic. – Tomalak Apr 11 '22 at 13:38
2 Answers
0
Each record requires unique fields. So for each record within a query, the fields will be unique by definition. If you have multiple records, however, you might have the same field twice. For example, a query with multiple records with descr will have multiple descr fields in the output. By default, they will all share the same label in the output, so the column labels will not be unique (by default). You can change this from the fields tab. Click the Edit button next to the field you would like to change. You will then see a Heading Text and a Unique Field Name. You may change both of them, although the unique field name is already unique across the columns in the query, and is usually the record alias.field, for example, B.DESCR.
jim.marion
- 149
- 2
0
Click on the properties of the query Properties
Check Distinct in the Properties Page Check Distinct in the Properties Page
4UR3L10
- 1
- 1
-
Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Apr 11 '22 at 18:19