Table of Contents

Search

  1. Preface
  2. Transformations
  3. Source transformation
  4. Target transformation
  5. Aggregator transformation
  6. Cleanse transformation
  7. Data Masking transformation
  8. Deduplicate transformation
  9. Expression transformation
  10. Filter transformation
  11. Hierarchy Builder transformation
  12. Hierarchy Parser transformation
  13. Hierarchy Processor transformation
  14. Input transformation
  15. Java transformation
  16. Java transformation API reference
  17. Joiner transformation
  18. Labeler transformation
  19. Lookup transformation
  20. Mapplet transformation
  21. Normalizer transformation
  22. Output transformation
  23. Parse transformation
  24. Python transformation
  25. Rank transformation
  26. Router transformation
  27. Rule Specification transformation
  28. Sequence Generator transformation
  29. Sorter transformation
  30. SQL transformation
  31. Structure Parser transformation
  32. Transaction Control transformation
  33. Union transformation
  34. Velocity transformation
  35. Verifier transformation
  36. Web Services transformation

Transformations

Transformations

Structure Parser field mapping

Structure Parser field mapping

Configure the field mapping in a Structure Parser transformation to define which fields in the source transformation to map to fields in the Structure Parser transformation. Configure field mappings on the
Field Mapping
tab of the
Properties
panel.
The Structure Parser contains the following Field Mapping fields in the
Structure Parser Input Fields
panel:
Data
Used to map the data field in the source transformation to the data field in the Structure Parser transformation. Map this field for a Hadoop Files source and for a Structure Parser transformation that is used midstream.
File Path
Used to map the file path or reference file in the source transformation to the file path field in the Structure Parser transformation.
You can configure the following field mapping options:
Field Map Options
Determines how field names appear in the Structure Parser transformation input fields list. Use technical field names or labels.
  • Manual. Manually link incoming fields to target fields. Removes links for automatically mapped fields.
  • Automatic. Automatically link fields with the same name. Use when all of the fields that you want to link share the same name. You cannot manually link fields with this option.
  • Completely Parameterized. Use a parameter to represent the field mapping. In the task, you can configure all field mappings.
  • Partially Parameterized. Use a parameter to configure links in the mapping that you want to enforce, and display unmapped fields in the task. Or, use a parameter to configure links in the mapping, and allow all fields and links to display in the task for configuration.
Automap
Links fields with matching or similar names. Allows you to link matching fields, and then manually configure other field mappings.
Show Fields
Controls the fields that appear in the
Incoming Fields
list. Show all fields, unmapped fields, or mapped fields.

For a Hadoop Files source

For a Hadoop Files source, map the
Data
and the
File Path
fields in the
Incoming Field
panel to the same fields in the
Structure Parser Input Fields
panel. You can use the
Automap
option to automatically map these fields.

For a flat file source

For a flat file source, map the field in the
Incoming Field
panel to the
File Path
field in the
Structure Parser Input Fields
panel.

For a Structure Parser transformation that is used midstream

When using a Structure Parser transformation midstream, that is not after the source transformation, map the incoming data ports to fields in the
Structure Parser Input Fields
panel.