You need to split a single string column containing delimited values (e.g., 'Apple,Banana,Cherry') into separate rows. Which TWO tools can accomplish this? (Select two)
Trap 1: Formula tool
While the Formula tool can use functions like GetWord or Replace, it primarily modifies existing values within a column. It does not possess the inherent capability to explode a single row into multiple rows based on a delimiter, making it unsuitable for this specific structural transformation task.
Trap 2: Summarize tool
The Summarize tool is designed for aggregation, such as counting, summing, or concatenating values into a single string. It performs the exact opposite operation of what is required here; it combines multiple rows into one, whereas the task requires splitting one row into multiple.
Trap 3: Filter tool
The Filter tool is used strictly for conditional evaluation, separating data streams based on True or False logic. It does not modify, create, or split data structure beyond removing unwanted records, meaning it cannot parse or redistribute string content across new row entities.
- A
Text to Columns tool
The Text to Columns tool is the most direct way to handle delimited data. By selecting the 'Split to rows' option, it dynamically generates a new record for every parsed value found in the string, making it an efficient choice for normalizing data that arrives in a combined list format.
- B
Regex tool
The Regex tool is extremely powerful for parsing strings. By configuring the output method to 'Parse' or 'Tokenize', you can effectively split delimited text into multiple rows. This method is preferred when the delimiter structure is complex or requires pattern matching beyond simple character-based splitting logic.
- C
Formula tool
Why it fails: While the Formula tool can use functions like GetWord or Replace, it primarily modifies existing values within a column. It does not possess the inherent capability to explode a single row into multiple rows based on a delimiter, making it unsuitable for this specific structural transformation task.
- D
Summarize tool
Why it fails: The Summarize tool is designed for aggregation, such as counting, summing, or concatenating values into a single string. It performs the exact opposite operation of what is required here; it combines multiple rows into one, whereas the task requires splitting one row into multiple.
- E
Filter tool
Why it fails: The Filter tool is used strictly for conditional evaluation, separating data streams based on True or False logic. It does not modify, create, or split data structure beyond removing unwanted records, meaning it cannot parse or redistribute string content across new row entities.