Drop All Events to Start With
Overview
Drop All Events to Start With removes all events that begin with a user-defined value.
Description
This operation scans event values and drops all entries that start with the specified prefix. It is useful for filtering out unwanted records based on starting patterns.
Number of Parameters
1
Parameter: Drop All Event To Start With
Specify the starting value from which events should be dropped.
"https"
Drop All Event for Value
Overview
Drop All Event for Value removes all occurrences of a specified value from an event.
Description
This operation drops all records containing the defined value, enabling precise data filtering.
Number of Parameters
1
Parameter: Drop All Event For Value
Specify the value to be removed.
"Michael"
Eliminate
Overview
Eliminate removes specific key names from the dataset.
Description
Users provide one or more key names to remove them completely from the data structure.
Number of Parameters
1
Parameter: Eliminate
Provide the key names that should be removed.
"Organization","Item"
Substitute
Overview
Substitute replaces an existing value, word, or character with a new value.
Description
This operation modifies a key’s value based on user-defined replacement rules.
Number of Parameters
1
Parameter: Substitute
Format: [“key_name”,”value_to_replace”,”new_value”]
"email-id",".in",".com"
Rename
Overview
Rename changes an existing key name to a new user-defined key name.
Description
This operation accepts key-value pairs where the key is the original name and the value is the new name.
Number of Parameters
1
Parameter: Rename
"email":"email-id"
Strip
Overview
Strip removes specified characters from the left, right, or both ends of a value.
Description
This operation cleans unwanted characters such as whitespace or line breaks.
Number of Parameters
1
Parameter: Strip
"TableData","right","\n"
Substring
Overview
Substring extracts a portion of a string based on index slicing.
Description
Users define slicing patterns to retrieve specific characters or ranges from a string.
Number of Parameters
1
Examples
"string":"[0:5]" Response: freeC
"string":"[2:6]" Response: eeCo
"string":"[-1]" Response: p
"string":"[-5:]" Response: eCamp
"string":"[1:-4]" Response: reeCode
"string":"[::2]" Response: feCdCm
"string":"[bizdata_substring.index("_") + 1:]"
Response: 123
Frequently Asked Questions
What is the purpose of Drop All Events to Start With?
It removes all events that begin with a specified prefix.
Can Eliminate remove multiple keys?
Yes, multiple key names can be provided as comma-separated values.
How does Substitute work?
It replaces a defined value within a specified key with a new value.
Does Rename change the data structure?
It only updates key names while preserving associated values.
What is Substring used for?
It extracts specific portions of a string using index-based slicing.
Notes
- Ensure correct parameter formatting before execution.
- Test transformations in preview mode before production use.
- Apply operations sequentially for structured data cleaning.
