now how to compare both the columns values? Column D and column F have the Dates (dd/mm/yyyy) format
column Dcolumn F 1/1/2018 1/1/2018 (if same value then ignore)
_20/1/2018 30/1/2018
20/1/2018 _30/1/2018(_consider this value , as i want different date values for both the columns , consider the rows with different column values ) i am having like this many rows for these columns..
when u get different value for Column D and column F then u should click on to the cell present in same row in column A
when u get different value for Column D and column F then u should click on to the cell present in same row in column A i dint understand this, what do u mean by click
The point number 2, that is :
if dr(“Column D”)<> dr(column F ) then
click on the column A’s Cell
End if
So how to click the particular cell corresponding to the above condtion?
do i need to change the selector of click activity, n if yes how to change it? n it should happen dynamically(as its a big table)
n one more condition i have to take care that is → dr(“Column D”)<> dr(column F ) and also if Column M =" "(if column M has any new value in it then program should ignore that particular row…
How to do this??
step1: there is a report created in the SAP.(this report usually have too many rows some time 100 some time 20 some time 50 rows etc… dynamic)
Step2: find the difference between 2 columns(these 2 columns have the dates) and in 3rd column if “x” is present then we should not click on column A cell of the table. we have to do this row by row. i mean loop through the table.
Step3: when i click on this cell A( the Uipath should click it on its own ) in the same row where above step 2 condition is satisfied it opens the next screen
well - Here you need right click activity to click on the cell
Sure i will do right click. But as i said its in a loop - so i will put for each loop(i can use the for each loop). and i want this right click to be dynamic(means click on A22,A99, A100 once the condition is full filled)… that is - as i loop through then where ever the condition is full filled there it should automatically go n double click the hyper link present in the the A cell.
Some times cell A5, some times Cell A99 , A22, A60 etc…
well one more question, i am able to take this entire table to excel sheet as shown in screen shot. but not able to take it to Datatable.
Well thanks for all ur quick response. i will try the solutions provided by you.
The piece of code which you mentioned above in RPA is not working,
n i added the If activity, tried to write the code - if datarow(column1)<>datarow(column2) and datarow(column10) =“X”
well its showing compiler error…
Please find the screen shot.
Also do i need to write any select queries? for which ever row the condition is full filled should be copied to another datable and excel.
i just found in uipath site one select query, but i am not getting how to modify it for the columns and write the colndition for IF block
(From p in datatable.Select() where Not p(“Name”).ToString.Split({" "},StringSplitOptions.RemoveEmptyEntries).Any(Function(d) p(“Company”).ToString.Contains(d)) Select p).ToArray.CopyToDataTable()
i feel its a linq query.
So similarly can we change the above code for the columns
This particular code is able to satisfy only one condition that is - DT1.Select(“col1< >col2 And col3=’’”).CopyToDataTable() — i have made it bold
But its not wotking for col3-“” → if column 3 contains any value then it should be ignored. if its blank then only we should consider…
Please help me out with this
Ok you are right, but how should i put it in “If Activity” , i had used it with the assign activity. can u put a screen shot or a .xaml file, also one more thing is that once both the conditions are full filled i have to use the for each loop to scrape other activities.
i just want to know which activities to be used . can you share a .xaml for this please…
Ho i am really sorry,
Actually both the conditions should be satisfied at one shot.
Yes both should and must be true then only i should be able to put it in to the DT.
after that there is big for each loop i have to put…