Hi Iam trying to automate in customers data trying to join first name and last name from excel column and store value in new column as full name ! Iam using excel process scope but Iam getting error do:- column first name does not exist ! How to solve it !
Can you share screen shot of your workflow.
Hi @Zara_Choudhary, welcome to the Community.
You can consider this approach as your objective is to write a full name in another column.
- Read the excel data using Read Range activity & store the result in a datatable variable dt.
- Add a column named FullName using the activity Add Data Column.
- Implement this query inside an Invoke Code activity:
row(“FullName”) = row(“FirstNameColumn”).ToString + “ “ + row(“LastNameColumn”).ToString
- Write the datatable dt into an excel file using Write Range activity.
Hope this helps, please let us know for any further assistance,
Welcome to the community
As you already have data in excel…you can use excel formula for this
In the column you want the full name say it is C and say data is there in A and B columns
Then use a write cell activity with cell as
"C2" and value as
Then use a auto fill range activity and give the range in it and the formula would be filled till the end
Hope this helps
Thank you !