How to use datatable.select()?

I used select method to find age column better than 5 olds.
But these results came back.
assign activities dataRow = sampleData.Select(“age>5”)
for each activities row(“name”).ToString + " " +row(“age”).ToString
table column is name, age
result
Let me know why this is happening

1 Like

buddy @SungwookJ
you were almost right buddy
Kindly change like this buddy
dataRow = sampleData.Select("[age]>‘5’")

Kindly try this and let know buddy
Cheers

1 Like

Did that work buddy @SungwookJ

@Palaniyappan
I tried sampleData.Select("[age]>‘5’") method .
However, these results returned.
result2
I don’t understand why 40, 100 years old is not returned.

Thanks for the reply.

1 Like

Buddy then try with filter datatable activity
like this and you can get the data from the out_dt buddy @SungwookJ

Cheers

Yup, Filter data table is the way to go.

That select statement is somehow not taking the correct syntax (at least according to me)

Can you share the .xaml? maybe we can help further, there might be some other issue…:slight_smile:

Regards

@SungwookJ,

Can you please use this logic:

DT1 = sampleData.Select(("[age]>5")).CopyToDataTable

And iterate the value in foreach of this datatable DT1. I have created sample workflow for your case. Please check and let me know.

FilterDataTableBasedOnColumn.zip (12.1 KB)

Thanks,
Arunachalam

3 Likes

thank you for your help.
i resolved that.

1 Like

@SungwookJ,

Can you please mark as valuable solution so that our folks can get info of this window :slight_smile:.

Thanks,
Arunachalam.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.