Select query in a data table where column name is integer

[Surya_Narayana_Korivipadu]

I have a column with the name 23 in my data table. I’m not able to run select query with that column name as shown in above screenshot. If the correct syntax is provided, the above query should return 1 as result. But it’s not working with my query. How to solve this?

[Yoichi]

Hi,

Can you try the following LINQ expression instead of Select method?

MainExcelDT.AsEnumerable.Count(Function(r) r("Name of mentor").ToString="Dr. S. VENKATESWARLU" AndAlso r("COLLEGE").ToString="GPCET" AndAlso r("BRANCH").ToString="MEC" AndAlso Int32.Parse(r("Year").ToString)=3 AndAlso Int32.Parse(r("23").ToString)>65)

Regards,

[Surya_Narayana_Korivipadu]

ok. I’ll try that. Can I also use variables instead of values in this query?

[Yoichi]

Hi,

@Surya_Narayana_Korivipadu

Can I also use variables instead of values in this query?

Yes, as the following.

MainExcelDT.AsEnumerable.Count(Function(r) r("Name of mentor").ToString=strDrName AndAlso r("COLLEGE").ToString=strCollegeName AndAlso r("BRANCH").ToString=strBranchName AndAlso Int32.Parse(r("Year").ToString)=intYear AndAlso Int32.Parse(r("23").ToString)>int23Value)

Regards,

[Surya_Narayana_Korivipadu]

Tried. I’m getting the same error:

[Yoichi]

Hi,

In my environment, I got same error in immediate panel. However it works in activity such as MesageBox, for example. Can you try the expression in an activity?

Regards,

[SamanGuruge (Palliya Guruge Saman Priyalal)]

Hi @Surya_Narayana_Korivipadu ,

Just pass your result into a List(convert to a list) then check the count. List work with if there no matches but DT are don’t work that way

[Surya_Narayana_Korivipadu]

Ok. I’ll try

[Surya_Narayana_Korivipadu]

Did you mean that I should convert entire data table to list

[SamanGuruge (Palliya Guruge Saman Priyalal)]

In your LINQ query convert result to list by using .ToList function and after that check the result count. basically goal is convert your LINQ result into a list and after that check the count

[Surya_Narayana_Korivipadu]

When I tried in Assign activity, I’m getting error:

[SamanGuruge (Palliya Guruge Saman Priyalal)]

as per this image

sorry do not run the Count function just run SELECT or WHERE function and pass it as list and take the count

[Yoichi]

Hi,

It seems there are non-int32 value (include blank) in Year and/or 23 column.
So, for now, can you try the following expression?

MainExcelDT.AsEnumerable.Count(Function(r) r("Name of mentor").ToString=strDrName AndAlso r("COLLEGE").ToString=strCollegeName AndAlso r("BRANCH").ToString=strBranchName AndAlso  Int32.TryParse(r("Year").ToString,New Int32) AndAlso Int32.Parse(r("Year").ToString)=intYear AndAlso Int32.TryParse(r("23").ToString,New Int32) AndAlso Int32.Parse(r("23").ToString)>int23Value)

Regards,

[Surya_Narayana_Korivipadu]

I’m not sure if this works. I’ll convert my column name to string like day 23. Then it will work

@Yoichi @SamanGuruge

[Surya_Narayana_Korivipadu]

I converted my column name to Day 23 and tried the following. Nothing works

@Yoichi @SamanGuruge