Copy and paste one column in other column in same excel sheet

Help Activities
, , ,
1

I have an excel sheet with column of Nameofclient, customerID, Customer name and Company ID. copy Nameofclient column and paste into customer name column and copy customer ID column and paste into company ID column in same excel sheet.

2

Hi @lokeshkumar.k

Have a look on the video link

Share the sample input and output?

Regards
Gokul

3

Hello @lokeshkumar.k ,

Either you can use the for each loop or the linq for this
assign
dt = dt.Clone
by clonoing you will get the structure of input datatable
Linq
(From row in dt.AsEnumerable
Select clonedt.LoadDatarow(New Object(){
row(“Nameofclient”).ToString,
row(“customerID”).ToString,
row(“Nameofclient”).ToString,
row(“customerID”).ToString
},False)).CopyToDataTable

4

Hi @lokeshkumar.k ,

try to user “Update row item” activity. like below mentioned workflow

image
image413×657 22.1 KB

ColumnValueAddToDataTable.xaml (10.1 KB)

Thanks,
Raj

5

(From row In Passport_Date_Filtration.AsEnumerable
Select ClonePassport_Date_Filtration.LoadDatarow(New Object(){
row(“NameOfClient”).ToString,
row(“CompanyName”).ToString,
row(“CustomerID”).ToString,
row(“CompanyID”).ToString
},False)).CopyToDataTable

I got this error. LoadDatarow is not a member of string

6

try to use the below code
(From row in Passport_Date_Filtration.AsEnumerable()
Select ClonePassport_Date_Filtration.LoadDataRow(New Object({
row(“NameOfClient”).ToString,
row(“CompanyName”).ToString,
row(“CustomerID”).ToString,
row(“CompanyID”).ToString
},false)).CopyToDataTable

7

Input - Copy.xlsx (10.9 KB)
I attached sample excel file and mentioned copy and paste column in colour
Nameofclient —> Customer Name
CustomerID -----> Company ID

8

image
I got this error

9

I tried this but its not wroking.
Input - Copy.xlsx (10.9 KB)
I attached the Input file and mark the column name in colur

10

Can you share the Output also @lokeshkumar.k

11

Hello @lokeshkumar.k
Kindly Refer this Xaml file
Forum_CopyPasteColumn.zip (75.0 KB)

image
image1310×369 22.7 KB

12

I just want to copy one column into other column from this input sheet. I attached a output file and i need a output like that
Input - Copy.xlsx (10.9 KB)

13

@lokeshkumar.k

Above Xaml file may helps for you. Kindly to refer this

14

Hi @lokeshkumar.k

Check out the XAML file

image

CopyPasteColumn.xaml (9.1 KB)

Output

image

Regards
Gokul

15

Thanks for your help. Data copied successfully

16

Do you have any other queries related to this topic @lokeshkumar.k

18

This One is a New Queries right?

Close this topic by mark as solved and create an separate topic for this. @lokeshkumar.k

Regards
Gokul

19

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