Copying data from another column in one sheet

Hi friends!
I’m new to uipath and can’t solve one problem. I need to filter a column by empty value and copy data from the adjacent column to fill in empty values, but then I should be able to remove the filter after filling in the data and get a column without empty rows. Please help me with this and sorry for my english
For example from this: image
to this: image

Hi @asiljan.7 !
Sure, here is a suggestion: Copy_data_to_adjacent_column.xaml (6.9 KB)
Before running the file, be sure to change the path name and the sheet name to be the same as yours (both in Read range and write range) !
Also, the version I am using is UiPath Studio 2021.4, if you see “Missing activities” when opening the file, let us know and give us the version of UiPath Studio you’re using so that we adapt the code to your requirements :wink:
Let us know if that’s not what is expected !

Hi @asiljan.7

You can do this in a single approach

Read the excel file and store in dt1

Then use invoke code and use the following code with dt1 as in/out argument.

dt1.AsEnumerable().Where (Function(row) row(“Letters”).ToString.Equals("")).ToList().ForEach(Sub(row) row(“Letters”)= row(“Numbers”).ToString)

Then write the dt1 using write range

Try this and let me know if it works

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

1 Like

hi @Hiba_B
Thanks for answering, the version of uipath is exactly the same as yours, but here an error occurred with an unrecognized activation image

Hi @NIVED_NAMBIAR , thanks for the reply. I got this error, tell me what it can mean?


the type of the argument specified this way

Let me check

in the value specify the dt1


For quick reference use this workflow
process1.zip (1.7 MB)

Input file i used
image

output file i got

image

Attached the sample excel file in the workflow for reference.

Regards,
Nived N
Happy Automation

it works! thank you very much! Please advise what I need to do to learn to code as well as you :wink:

1 Like

You can try to learn c# or vb.net. There are many youtube resources on this

For learning linq query
you can check out some resources in forum itself,

Regards,
Nived N
Happy Automation

1 Like

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