Hi I have excel date like below, ID First Name Middle Name Profession Email 100093 James Agnes Kong Teacher james@xyz.com 100093 James Agnes Kong Teacher james@xyz.com 100579 Kevin Tan Engineer kevin@xyz.com 100579 Kevin Tan Engineer kevin@xyz.com 100579 Kevin Tan Engineer kevin@xyz…

Buddy what do you mean the length here buddy. i hope you are talking about the length of the string like 10093, but even though its length is 5 but you meant like its showing correctly with 2 [image] siszack: dt1.Select("[ID]=‘100093’ “).length it returns correctly as 2, i didn’t get that b…

HI @siszack May be you are having a small space or a tab in front or at the end. Try to trim the column data before using the select command. Or else, you can use the like command in the select command. If you are using the trim, you can use a for each row activity to trim the values in the comman…

Hi Palaniyappan, What I meant for the length is the number of datarows. I checked there are no white spaces and also I have used trim functions and its same.

you can get the data rows with this itself buddy outdt.Rows.Count once after the filtering with select or you can use FILTER DATATABLE ACTIVITY buddy with this activity you can pass the datatable you have and make the filter by mentioning the columnname and the value to be filtered with and fina…

For this, you can use Like or “IN” MS SQL operator for the correct Out of this Database. The IN operator allows you to specify multiple values in a WHERE clause. The IN operator is a shorthand for multiple OR conditions.

Hi @siszack The best option would be to use the Filter Data Table activity for this kind of activities. IT would be the best option. This will return a filtered datatable. Then using that datatable you can get a row count which gives you the exact row count To get the row count: FilteredDT.Rows.Co…

hello @siszack you can try this instead of Length dt1.Select("[ID]=‘100093’ “).count Thanks

Hi @Lahiru.Fernando @Palaniyappan , What I did was to get the datatable count by using dt1.Rows.count and then I use another read range activity to specify the ID column range like A1:dt1.Rows.count and then get the output dt2. I then use remove duplicate rows activity to remove the duplicate ID v…

.count and .length gives me same output

Datatable select query not giving correct result

Help

Tiberiu_Niculescu (Tibi) May 29, 2019, 9:32am 2

try using the LIKE operator. Dt.select using like

Topic		Replies	Views
Select query in datatable getting from Excel file Help activities	14	2797	May 3, 2019
The source contains no DataRows Help datatable , selector , activities , error	18	24363	April 12, 2022
.netのselect文に関してフォーラム	7	1636	February 21, 2019
Search value in the datatable Help	15	22681	July 28, 2017
Datatable count Learning Hub	4	791	May 27, 2020

Datatable select query not giving correct result

Related topics