Transform Examples

  1. Add a Sequence Number Column Transform Assign Field Calculated Field
  2. Add a Sequence Number Column for Repeat Values Transform Assign Field Calculated Field
  3. Add a Sequence Number Column when Values Change Transform Assign Field Calculated Field
  4. Cache Lookup Values Transform Lookup JDBC Cache
  5. Collapse Numbered Siblings in JSON Transform JSON DataPipeline Foundations Version 11.0.0
  6. Collapse Numbered Siblings in XML Transform DataPipeline Foundations Version 11.0.0 XML
  7. Conditionally Transform Data Transform Assign Field Filter JSON Simple
  8. Conditionally Write to Multiple Files Transform Multi-writer Threading
  9. Convert OFX Transactions to CSV OFX Transform CSV Version 11.0.0
  10. Copy a Field Transform Copy Field
  11. Detect Records in Date-Keyed JSON Transform JSON DataPipeline Foundations Version 11.0.0
  12. Detect Records in JSON with Header and Details Transform JSON DataPipeline Foundations Version 11.0.0
  13. Extract Bigrams, Trigrams, and Ngrams Transform Analyze Data XML
  14. Filter Records Expression Language Transform Filter Rules
  15. Find The Minimum Maximum Average Sum Count Transform Stats CSV Aggregate Conversion STDOUT
  16. Generate SQL SELECT from Pipeline Actions Transform JDBC DataPipeline Foundations Version 11.0.0
  17. Get a Query Param from a URL Transform Assign Field
  18. Handle Filtered Records Transform Assign Field Calculated Field Fixed Width Filter
  19. Handle Transforming Reader Failures Exceptions Transform Filter Rename Field XML
  20. Handle Transforming Writer Failures Exceptions Transform Calculated Field Fixed Width Filter Conversion
  21. How to Convert Tabular Data to Trees Using Aggregation Transform CSV Sort
  22. Lookup Data in a Database Transform Lookup JDBC
  23. Lookup Data in any Data Reader Transform Lookup
  24. Lookup Using RecordList Transform Lookup Version 10.1.0
  25. Lookup in a Flat File Transform Lookup
  26. Manipulate Fields Transform Conversion In-Memory
  27. My Proxy Reader Transform Customize
  28. My Proxy Writer Transform Customize
  29. My Transformer Transform Customize
  30. Query JSON using JSONata Transform JSON JSON Lines Version 11.0.0
  31. Read an XML File (2) Transform JDBC Conversion XPath XML
  32. Read and Transform Data in Parallel Transform Threading
  33. Remove Duplicates Transform Remove Duplicates (Dedup)
  34. Remove Fields Transform Exclude Fields
  35. Remove/Retain Duplicate Fields Transform Remove Duplicates (Dedup)
  36. Rename Duplicate Fields Transform Rename Field
  37. Rename Duplicate Fields with a Separator Transform CSV Version 11.0.0
  38. Rename Fields Containing Spaces and Symbols Transform Rename Field
  39. Rename Fields Quickly in Flat And Tabular Data Transform Tabular Data Flat Data Performance Rename Field Fast Version 8.1.0
  40. Rename a Field Transform Rename Field
  41. Search Twitter for Tweets Transform Twitter MS Excel Copy Field Multi-writer STDOUT
  42. Select and Arrange Fields Transform Include Fields
  43. Set a Calculated Field Programmatically Transform Assign Field Calculated Field
  44. Set a Calculated Field at Runtime Expression Language Transform Assign Field Calculated Field
  45. Set a Field Transform Assign Field
  46. Sort Records Transform Sort
  47. Specify Lookup Values Programmatically Transform Lookup
  48. Use Functions In Transformers Java Streams Transform Version 10.1.0 Filter Customize Lambda
  49. Use Predicates in Filters Java Streams Transform Version 10.1.0 Filter Customize Lambda
  50. Use Structure-Based Sibling Collapse Transform JSON DataPipeline Foundations Version 11.0.0
  51. Use a Regex Rule to Detect Records Transform JSON Customize DataPipeline Foundations Version 11.0.0
  52. Validate Incoming Data Expression Language Transform Validate Rules
  53. Write A Parquet File Containing Spaces And Symbols In Column Names Transform CSV Parquet
  54. Write my own Filter or Validator Transform Filter Validate Customize
  55. Write my own Lookup Transform Lookup Customize
  56. Write my own Transformer Transform Customize

All Examples

Mobile Analytics