Compare DD

Build
#1

Hi all ,

I am having a Datatable , which has many columns

now how to compare both the columns values?
Column D and column F have the Dates (dd/mm/yyyy) format

column D column 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

Can any one please guide me?

Sonika

#2

Can any one please help me with this issue…
Please

#3

you can try this,

  1. compare two columns of a datatable using

For Each dr as DataRow in dt.Rows

If dr(“col1”)<>dr(“col2”)

Then --your condition

End If

Next

  1. 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

thanks
Yogananda

#4

Hi Ananda,

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??

Its a SAP application.

Hope i have explained good. i tried my best

Thank you
Sonika

#5

you want to click on a particular cell, does cell contain any objects or what you are trying to perform with it,

give us a screenshot or something to understand better.

thanks
Yogananda

#6

Hi Ananda,

Yes sure I have attached the screen shot.

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

Regards,
Sonika

#7

you can try this,

  1. compare two columns of a datatable using

For Each dr as DataRow in dt.Rows

If ((dr(“col1”)<>dr(“col2”)) or col(outbound) ==“X”))

Then --your condition

Here you need right click activity to click on the cell

try to use recording to click cell and check selector to use

End If

Next

Thanks
Yogananda

#8

Hi Yogananda,

I previously addressed u wrongly , i am sorry.

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.

Regards,
Seema

#9

Hi ,

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.

Please help me out

Thank you,

#10

Hi Yogananda,

Can you please help me out with this issue. Thanks in Advance

Sonika

#11

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

i need immediate help.

Can anyone there please help me

#12

p1.zip (9.4 KB)

This is the workflow which compares two colmns( I have used col1 and col2). if both matches it will store the result rows into new datatable.

thanks
Yogananda

#13

Hi Yogananda,

I did it in the following way
DT1.Select(“col1< >col2 And col3=’’”).CopyToDataTable()

Regards
Sonika

#14

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

#15

i have doubt,

  1. you need to satisfy any one conditiobn in this col1< >col2 or col3=’’”

  2. you want to verify both to true, then only it should work

as for your prob, even when i tried its not accepting both the conditions.

–> For this you can try like this use two if conditions,

if DT1.Select(“ col1< >col2).CopyToDataTable()

if DT1.Select(“ **col3="" **).CopyToDataTable()

from here you can merge the datatable or use two seperate datatable for your operations

thanks

#16

Hi Yogananda,

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…

Thank you
Sonika

#17

you dint answer my ques,

  1. you need to satisfy any one conditiobn in this col1< >col2 or col3=’’”
  2. you want to verify both to true, then only it should work
1 Like
#18

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…

#19

excel.xaml (9.6 KB)
Book1.xlsx (8.0 KB)

Try this i have used Linq query for col1< >col2
and filter datatable for col3=’’X”

change it according your need ( Filter datatable )

Thanks

#20

n nj nn