Table of Contents

Search

  1. Preface
  2. Introduction to Transformations
  3. Transformation Ports
  4. Transformation Caches
  5. Address Validator Transformation
  6. Aggregator Transformation
  7. Association Transformation
  8. Bad Record Exception Transformation
  9. Case Converter Transformation
  10. Classifier Transformation
  11. Comparison Transformation
  12. Consolidation Transformation
  13. Data Masking Transformation
  14. Data Processor Transformation
  15. Decision Transformation
  16. Duplicate Record Exception Transformation
  17. Expression Transformation
  18. Filter Transformation
  19. Hierarchical to Relational Transformation
  20. Java Transformation
  21. Java Transformation API Reference
  22. Java Expressions
  23. Joiner Transformation
  24. Key Generator Transformation
  25. Labeler Transformation
  26. Lookup Transformation
  27. Lookup Caches
  28. Dynamic Lookup Cache
  29. Match Transformation
  30. Match Transformations in Field Analysis
  31. Match Transformations in Identity Analysis
  32. Normalizer Transformation
  33. Merge Transformation
  34. Parser Transformation
  35. Python Transformation
  36. Rank Transformation
  37. Read Transformation
  38. Relational to Hierarchical Transformation
  39. REST Web Service Consumer Transformation
  40. Router Transformation
  41. Sequence Generator Transformation
  42. Sorter Transformation
  43. SQL Transformation
  44. Standardizer Transformation
  45. Union Transformation
  46. Update Strategy Transformation
  47. Web Service Consumer Transformation
  48. Parsing Web Service SOAP Messages
  49. Generating Web Service SOAP Messages
  50. Weighted Average Transformation
  51. Window Transformation
  52. Write Transformation
  53. Appendix A: Transformation Delimiters

Developer Transformation Guide

Developer Transformation Guide

Update an Output Group

Update an Output Group

You can update a Normalizer transformation output group. You can add or remove the fields in the group.
By default, the Developer tool creates level 1 output groups when you define an input hierarchy. The Developer tool does not include records in the groups. You can update the default output groups and add records to them.
To update an output group, highlight the group name and click
New
Update Group
. The
Edit Output Group
dialog box shows the fields in the input hierarchy. Choose which fields to include in the group.

Update Output Group Example

In the previous example, the Developer tool created a default output group with the CustomerID, FirstName, and LastName fields.
The following image shows the default output group:
The default output group contains the CustomerID, FirstName, and LastName.
You can update the default output group and add the Address record to it.
The following image shows the
Edit Output Group
dialog box:
The Edit Output Group disalog box shows all of the fields from the Input Hierarchy selected.
In this example, the CustomerID, FirstName, and LastName are level 1 nodes. The Address record is also a level 1 node. The Normalizer transformation can return Address in the same row as the customer data. Since Address is multiple-occurring, the Developer tool adds the GCID_Address index to the output gorup.
The following image shows the ports in the Output group:
The Output group contains all the fields in the Input hierarchy and it includes a GCID address field.
When the customer fields and the multiple-occurring address fields are in the output group, the Normalizer transformation returns the same customer fields for each instance of the address data.
The following example shows the rows that the Normalizer transformation generates from the output group:
100, Robert, Bold, 100 Summit Dr, Redwood City, CA, United States,1 100, Robert, Bold, 41 Industrial Way, San Carlos, CA, United States,2 200, James, Cowan, 85 McNulty Way, Los Angeles, CA, United States,1 200, James, Cowan, 55 Factory Street, Los Vegas, NV, United States,2
The GCID port contains the Address instance number. The GCID value is 1 or 2.

0 COMMENTS

We’d like to hear from you!