Numeric to Categorical
On this Page
Overview
This is a Transform type Snap that converts numeric fields into categorical fields. There are two available splitting options: splitting by values and binning.
Input and Output
Expected input
- First input view: A document that contains numeric fields.
- Second input view: A document that contains data statistics computed by the Profile Snap.
Expected output: A document that contains categorical fields.
Expected upstream Snaps:
- First input view: A Snap that has a document output view. Example: CSV Generator Snap.
- Second input view: A sequence of File Reader and JSON Parser Snaps. These Snaps read the data statistics computed by the Profile Snap in another pipeline.
Expected downstream Snaps: A Snap that has a document input view. Example: the Aggregate Snap, or a combination of JSON Formatter and File Writer.
Prerequisites
None.
Configuring Accounts
Accounts are not used with this Snap.
Configuring Views
Input | This Snap has exactly two document input views, the Data input view and the Profile input view. |
---|---|
Output | This Snap has exactly one document output view. |
Error | This Snap has at most one document error view. |
Troubleshooting
None
Limitations and Known Issues
None
Modes
- Ultra Pipelines: Works in Ultra Pipelines.
Snap Settings
Label | Required. The name for the Snap. Modify this to be more specific, especially if there are more than one of the same Snap in the pipeline. |
---|---|
Policy | The preferences for fields and encoding methods. For each policy, select the input field with categorical values, the encoding method, and the result field. |
Field | Required. The field that must be transformed. This is a suggestible property that lists all available fields in the input documents. Default value: None |
Rule | Required. The type of transformation to be performed on the selected field. Two options are available:
Default value: Split by Values |
Prefix/Values | Categorical values to be used to replace original numeric values. You can specify either a prefix or multiple values in this property. For example, if the prefix is "group", the values will be "group_1", "group_2" and so on. In case of specifying values, use comma "," to separate them. Default value: None |
Splits/Bins | The values to be entered into this property depends on the selection you made in the Rule property.
Default value: None |
Result field | Required. The result field that must be used in the output map. If the Result field is the same as Field, the values are overwritten. If the Result field does not exist in the original input document, a new field is added. Default value: None |
Snap Execution | Select one of the following three modes in which the Snap executes:
Default Value: Execute only |
Examples
Converting Numeric Data into Categorical Values
This pipeline demonstrates how you can use the Numeric to Categorical Snap to convert numeric fields into categorical fields.
Download this pipeline.
Downloads
Important steps to successfully reuse Pipelines
- Download and import the pipeline into the SnapLogic application.
- Configure Snap accounts as applicable.
- Provide pipeline parameters as applicable.