Skip to content
Infoveave Help

Concatenate Column

Description

Combines the values of multiple columns into a single column using a separator.

Input

Data only

Output

Transformed data with a new column containing the concatenated data.

Configuration Fields

  • Input Columns Allows the input of multiple column names.
  • Output Column Specifies the column name for the new concatenated column.
  • Include Original
    • Enabled Keeps the original data columns along with the output column.
    • Disabled Only includes the output column.

Sample Input

employee_idnameagedepartmentdesignation
E001John Doe32SalesSales Manager
E002Jane Smith28EngineeringSoftware Developer
E003Ali Khan40FinanceFinancial Analyst
E004Maria Gonzalez35MarketingMarketing Specialist
E005Rahul Sharma30IT SupportNetwork Administrator

Sample Configuration

alt text

Sample Output

employee_idnameagedepartmentdesignationEmp_info
E001John Doe32SalesSales ManagerE001, John Doe
E002Jane Smith28EngineeringSoftware DeveloperE002, Jane Smith
E003Ali Khan40FinanceFinancial AnalystE003, Ali Khan
E004Maria Gonzalez35MarketingMarketing SpecialistE004, Maria Gonzalez
E005Rahul Sharma30IT SupportNetwork AdministratorE005, Rahul Sharma