This documentation provides an overview of the Add Columns to CSV File Task feature in EA Connect. The Add Columns to CSV File Task allows users to merge multiple columns with a specified separator and create a new column in a CSV file within EA Connect.
¶ Creating and Executing the Add Columns to CSV File Task
To create an Add Columns to CSV File Task, follow these steps:
1.Open the EA Connect web application in your web browser.
2.Log in to your EA Connect account using your credentials.
3.Navigate to the "Build" menu.
4.Select the "Tasks" submenu.
5.In the Tasks section of EA Connect, click on the "Create New" button.
6.Provide a suitable name for the task to identify it in the future.
7.Select the "Add Columns to CSV File" task type from the available options.
8.Specify the input file that needs to be updated with the merged columns.
9.Provide a title for the merged column that will be created in the output file.
10.Check rowId box for adding rowId column.
11.Provide a desired name for the output file that will be generated.
12.Click on “Save” to save the task configuration.
13.Now go to “Flow” section and Click on “Create New”.
14.Fill required fields and click on “Add Task”. Then, select the Add Column to Csv Task.
15.Click on “Save” button to save the flow.
16.Now click on “Execute” button to execute the flow.
17.Review the logs to verify that the file has been successfully updated with the merged column.
¶ Conclusion
The Add Columns to CSV File Task feature in EA Connect allows users to merge multiple columns into a new column in a CSV file. By specifying the input file, columns to merge, merged column title, and output file name, users can enhance their data management and processing capabilities within their workflows and processes.