Excel data split and Append data in same excel

i done a workflow in which-
1.data read from excel
2.split data with respect to"/".
i want to append the result(splited data) in a new column of the same excel sheet.how can i do it?

1 Like

Hi @arijit1213

After reading Excel sheet data you will get Datatable as output.

Assume you have one column Name FirstName/LastName and it has arjit/kumar value

         1) Add new column to Datatable(Add Data Column actvity)
         2) Use for each row activity to iterate Datatable.
                     var1 = row(0).tostring.split(’/’)(0)        ==> arjit
                     var2 = row(0).tostring.split(’/’)(1)        ==> kumar
                     row(0) = var1
                     row(1) = var2

Last two assign action will store values in to two different columns.

I think this should solve your problem. let me know if need any help on this.

Regards,
Vijay.

1 Like

it works for only one data.
when the Reading excel contain more than one data it gives an error that A column name "FIRST_NAME"already belongs to this datatable.

Hey @arijit1213

Adding column should done only once. if it is present inside for each row loop please keep it on top of for each row activity.

if you can share sample input file i can frame workflow and give it you :slight_smile:

Regards,
Vijay.

1 Like

ok.
image
this is my read excel data.

Hey @arijit1213

please find attached workflow for your reference.

hopefully this should solve your problem. Happy automation. :slight_smile:

Regards,
Vijay

BlankProcess3.zip (28.2 KB)

1 Like

Thank you…

Thank you…it works.
i am facing an issue related to Data scraping.
Can i tell you about my issue in Data scraping?

Hey @arijit1213

Happy that it is working for you. :slight_smile:

I would suggest you to create new thread for your data scraping issue.

Regards,
Vijay.

already created

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