Copying data from another column in one sheet

[asiljan.7]

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:
to this:

[Hiba_B (Hiba Beldi)]

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
Let us know if that’s not what is expected !

[NIVED_NAMBIAR (NIVED N)]

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

Happy Automation

[asiljan.7]

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

[asiljan.7]

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

[NIVED_NAMBIAR (NIVED N)]

Let me check

[NIVED_NAMBIAR (NIVED N)]

in the value specify the dt1

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

Input file i used

output file i got

Attached the sample excel file in the workflow for reference.

Regards,
Nived N
Happy Automation

[asiljan.7]

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

[NIVED_NAMBIAR (NIVED N)]

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,

LINQ Query Syntax

LINQ Query – ExcelCult

Regards,
Nived N
Happy Automation