Wie können wir Ihnen helfen?
-
Latest Updates
-
Tool Suite 8.0
-
-
- Set field
- Verify field
- Verify field against reference value
- Read out field
- Call method
- Verify message
- Drag & Drop
- Browser instruction
- Call SAP function
- Call Data Manager
- Call ranorex test
- Verify PDF
- Set variable
- Verify variable
- Calculation
- Assemble text
- Extract text
- Save value to file
- Load value from file
- Insert Wait Step
- Insert screenshot manually
- Resize
- Close browser tab
- ... >15 <
-
-
- User interface - General
- User interface - Menu bar
- User interface - Table search / opened test cases
- User interface - Query editor
- User interface - Results area
- User interface - Parameters / variable mapping
- User Interface - Attachments
- Quick settings - Show intermediate results
- Used Shortcuts
- ... >1 <
-
-
-
Tool Suite 7.0
-
-
- Set field
- Verify field
- Read out field
- Call method
- Verify message
- Drag & Drop
- Browser instruction
- Call SAP function
- Call ranorex test
- Set variable
- Verify variable
- Calculation
- Assemble text
- Extract text
- Save value to file
- Load value from file
- Insert Wait Step
- Insert screenshot manually
- Resize
- Close browser tab
- ... >12 <
-
-
- User interface - General
- User interface - Menu bar
- User interface - Table search / opened test cases
- User interface - Query editor
- User interface - Results area
- User interface - Parameters / variable mapping
- User Interface - Attachments
- Quick settings - Show intermediate results
- Used Shortcuts
- ... >1 <
-
-
-
Tool Suite 6.4
-
-
-
- User interface - General
- User interface - Menu bar
- User interface - Table search / opened test cases
- User interface - Query editor
- User interface - Results area
- User interface - Parameters / variable mapping
- User Interface - Attachments
- Quick settings - Show intermediate results
- Used Shortcuts
- ... >1 <
-
-
-
Premium Support
-
- Artikel kommen bald
-
- Artikel kommen bald
< Zurück
Drucken
Unique
Veröffentlicht18. April 2023
Geändert14. May 2024
VonAlexandra Klettenhofer
Reduces the result to a unique subset using one or more column lists. It thus offers a similar functionality as GROUP BY or DISTINCT.
Example
In the following, a result table of 6 rows is generated with a ClientQuery. A unique filter with 2 column lists is applied to this.
--- !ClientQuery Id: Agents Statement: Select '007' as Agent, 1 as Part, 'a' as Project UNION Select 'Smith' as Agent, 2 as Part, 'b' as Project UNION Select 'Smith' as Agent, 3 as Part, 'c' as Project UNION Select 'Johnson' as Agent, 4 as Part, 'd' as Project UNION Select 'Scully' as Agent, 4 as Part, 'd' as Project UNION Select 'Mulder' as Agent, 4 as Part, 'e' as Project ResultFilters: - Unique: - [Agent] - [Part, Project]
Result:
Agent | Part | Project |
---|---|---|
007 | 1 | a |
Smith | 2 | b |
Johnson | 4 | d |
Mulder | 4 | e |
The second line for Smith was filtered out because it has already occurred once. The line Scully was filtered out because the value combination Part = 4 and Project = “d” has already occurred with Johnson.
Inhaltsverzeichnis