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:
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 !
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
Thanks for answering, the version of uipath is exactly the same as yours, but here an error occurred with an unrecognized activation
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
output file i got
Attached the sample excel file in the workflow for reference.
it works! thank you very much! Please advise what I need to do to learn to code as well as you
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,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.