Replace all values of a data table

Help
1

Hi
I have two data tables
DT1= 2000.00 2500.12 3000.25 etc (for each row)
DT2= 2,000 2,500 3,000(for each row)

please suggest how to compare these two tables since they contain “,” and decimal.

2

@KarthikBallary While Comparing use Convert.toDouble(row(“NumberColumn”).toString)

3

let that decimal value get converted to integer

4

@KarthikBallary Why Convert to Integer :sweat_smile:

5

2500 and 2500.12 are approximatelty equal. It must show it is equal. So I thought it would be better to convert them to integer

6

@KarthikBallary Upto What value Would you consider it as Approximately Equal?

7

It must not consider any decimal value

8

@KarthikBallary Try Comparing with Math.Floor(Convert.ToDouble(row(“NumberColumn”).toString))

9

i am using data filter activity for comparisions. I have two more columns to be compared

10

@KarthikBallary Can you tell us What operations do you want to perform in Detail :sweat_smile:

11

compare three coulms of first dt and three columns of second dt.
first dt is obtained from sql query. second from UI

12

@KarthikBallary How Do you Want to Compare the Columns? Do you want the Values to be Exactly Equal?

13

yes ignoring like(“,”) and decimals as I explained

14

after using for each row and then writing to excel still I am getting those , and I don’t see any decimal points

15

@KarthikBallary Can you provide the Excel Files :sweat_smile:

16

sample.xlsx (8.1 KB)

17

@KarthikBallary What about the Other Files?

18

sheet1 is of dt1 and sheet2 is of dt2.
what else u want?

19

@KarthikBallary Sorry Didn’t Notice the other Sheet :sweat_smile:

20

@KarthikBallary Ok, What Will be the Output of the Comparsion, in Which Format?