Across
- 3. Create or update columns based on one or more expressions to perform a broad variety of calculations or operations (7)
- 4. Combine two data streams based on common fields (4)
- 5. Organise records based on values in one or more fields (4)
- 8. Evaluate data by grouping, summing, counting, string concatenation and much more (9)
- 9. View data and data profile information from connected tool (6)
- 10. Parse, match, or replace data using regular expression syntax (5)
- 11. Query records based on an expression to split data into two streams, true or false (6)
Down
- 1. Pivot the orientation of data in a table by moving horizontal data onto a vertical axis (9)
- 2. Pivot the orientation of data in a table by moving vertical data onto a horizontal axis to summarize selected data (8)
- 6. Limit the data stream to a number, percentage or random set of records (6)
- 7. Combine two or more data streams with similar structures based on field names or position (5)
- 8. Re-order, remove, rename fields or change field types (6)
