Merging two column

Hi All,

I want to merge 2 column “B” and “C” then the
output of the merged data to be written in
“B” column. I.e B Column="B column "+“C column”
Please any help me to resolve this

Thanks,
Naveen S

@HeartCatcher

  1. Use Read Range activity to read the data from Excel file and will give output as DataTable. Let’s say ‘dtExcelData’.

    For each row in dtExcelData
    row(“B-ColumnName”) = row(“B-ColumnName”).Tostring +row(“C-ColumnName”).ToString

Ar the end use Write Range activity to write data into Excel file and pass DataTable ‘dtExcelData’.

1 Like

@lakshman


the excel as in attachment

@HeartCatcher

Can you please try above mentioned steps and let me know if you face any issues. Thank you.

Ok i will
thanks

Hi @HeartCatcher

Please find the solution in attached xaml file

Main.xaml (12.2 KB)

Thanks,
Saikrishna

@sai_krishna_somisetty ,
Thanks its working fine.
Now I want insert the output column between A column and B column(i.e B column will goes to C column and output should write in B column.

Thanks


That is as in the attachment I need to write the output in B Column

For this you need to use “Invoke method”,
TargetObject as DT.Columns("")

pass parameters as given screenshot

“Value” is the index position where you want to put the column.

image

Note: use second way

Hi,
Can you explain bit more how to use the Invoke method as
you said

“SetOrdinal” method is used to change the column position in datatable.

It takes input column name and position to move the given column to particular position.

its is not working for me could you please share workflow

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