Combine firstname and last name as full name

Help Activities
1

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 !

2

Hi @Zara_Choudhary

Can you share screen shot of your workflow.

3

Hi @Zara_Choudhary, welcome to the Community.

You can consider this approach as your objective is to write a full name in another column.

  1. Read the excel data using Read Range activity & store the result in a datatable variable dt.
  2. Add a column named FullName using the activity Add Data Column.
  3. Implement this query inside an Invoke Code activity:

dt.AsEnumerable.ToList.ForEach(Sub(row)
row(“FullName”) = row(“FirstNameColumn”).ToString + “ “ + row(“LastNameColumn”).ToString
End Sub)

  1. Write the datatable dt into an excel file using Write Range activity.

Hope this helps, please let us know for any further assistance,
Best Regards.

4

@Zara_Choudhary

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 "=CONCAT(A2,"" "",B2)"

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

Cheers

2 Likes
5

Thank you !

1 Like