Hello ,
Guys i just want to retrieve values of a column, based on the condition if the title matches.
ex: if(title = Name){ select both cris and leo}.
Please ping if you have solution
Thank you
Hello ,
Guys i just want to retrieve values of a column, based on the condition if the title matches.
Thank you
Thanks @Madhavi for the response.
And I’m just a rookie so not that familiar to it, Can you please say how to filter data-table ? I could only find “filter-table” activity and a option “use-filter” in read range activity. Can you please be specific in simple terms!
Hai @Madhavi ,
I encountered an issue that while retrieving column values , if it has same consecutive value it will consider only 1 value and i don’t want that to happen. Do you know how to stop that?
Hi, looking at @Madhavi’s solution, he is returning only one column but he used “true” to only take distinct values. I think you can change that to “false” and it will keep the duplicates, if I remember right.
dtInputData.DefaultView.ToTable(false, strColumnName)
As @ClaytonM mentioned, marking flag in ToTable to false will retain all the records.
Marking the flag to True will eliminate the duplicate records.