Join columns

Help Studio
, ,
1

In a Excel I have a table which contains 7 columns.
In that 2 column has same name and different value, So i need to combine both the column and concatinate their values.
eg.

image
image747Ă—54 2.1 KB

I have two columns have same name Size
How to do this?

2

@agathiyanv ,
1st of all you wont be able read it as a data table with headders (since there is duplicate name in headder)
So you will have to read the excel without checking “Add Headders”

3

Hi @agathiyanv ,

Could you maybe try using the below Component :

It will auto-rename the columns in the Datatable, You should be able to do the Operations later using the renamed columns.

Let us know if you require a different approach.

4

Steps I followed:
1.First change the column names(eg size_1,size_2) and Read the excel file
2.Create a new column using Add data column activity(columnName=“Size”)
3.Using for each row activity I assigned the value to the new column
CurrentRow(“Size”)=CurrentRow(“size_1”).tostring+CurrentRow(“size_2”).tostring
4.Now I remove the old columns using Filter Data Table activity.

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.