Split HTTP Query

Description

This activity splits the values of the specified column containing HTTP queries into multiple columns and parts.

Input

Data only

Output

Transformed Data

---

Configuration Fields

1. Column Name

   Allows single select, must contain HTTP queries as values.

2. Prefix

   Prefix for the column name which contains different parts of the query after transformation.

3. Include Original

   • Enabled Includes the data columns from the original data with transformed column.
   • Disabled Gives only the transformed columns.

---

Sample Input

employee_id	name	http_query
E001	John Doe	https://company.com/employee?id=E001&name=John+Doe&department=Sales
E002	Marie Dupont	https://company.com/employee?id=E002&name=Marie+Dupont&department=Marketing
E003	Carlos Gómez	https://company.com/employee?id=E003&name=Carlos+Gómez&department=Engineering

---

Sample Configuration

Sample Output

employee_id	name	http_query	Key_id	Key_name	Key_department
E001	John Doe	https://company.com/employee?id=E001&name=John+Doe&department=Sales	E001	John+Doe	Sales
E002	Marie Dupont	https://company.com/employee?id=E002&name=Marie+Dupont&department=Marketing	E002	Marie+Dupont	Marketing
E003	Carlos Gómez	https://company.com/employee?id=E003&name=Carlos+Gómez&department=Engineering	E003	Carlos+Gómez	Engineering

---