Concatenate Columns

By for October 20, 2016

74 views
64 downloads

Language

Report Abuse
Concatenate multiple columns into a single column.
This experiment shows how to combine various columns into a single column. This is reverse operation of "Text to Columns" custom module. ### Module Configuration ### This module expects set of columns to be merged and a delimiter to be used while merging ![](http://neerajkh.blob.core.windows.net/images/ConcatConfigCapture.PNG) ### Sample Input Dataset ### This example uses Bike Rental dataset to show the merge process. The figure below shows the data with fields highlighted that will be merged i.e. season, year, month and hour. ![](http://neerajkh.blob.core.windows.net/images/ConcatBeforeDataCapture.PNG) ### Sample Output Dataset ### The figure below shows the dataset after merge is complete. As you can see, the columns season, year, month, and hour are merged together with a comma delimiter ![](http://neerajkh.blob.core.windows.net/images/ConcatAfterCapture.PNG) ### Overall Sample Experiment Graph ### ![](http://neerajkh.blob.core.windows.net/images/ConcatOverallCapture.PNG) ### Source Code### The source code for this module is located here - [https://gist.github.com/nk773/8ea51168ce54c19ca1e7861f47338c3d](https://gist.github.com/nk773/8ea51168ce54c19ca1e7861f47338c3d)