Hi @emir_ozsimsir
I have assign the columnname as price and removed duplicates
If not met your need
Let me know
Cheers
1 Like
Datatablevaraible.AsEnumerable.GroupBy(Function(i) i(“columnName”).tostring).Select(Function(g) g.First).CopyToDataTable
Use above mentioned one
You are using the old query
1 Like
the code you gave worked but it found 140 results when it should have found 270 results I want to cry 
you and other users always help me thank you very much 
What you actual expect is not understanding
Other people like @Anil_G
Can definitely help you please make a sample input and expected output so that me or other people will help definitely
Happy to assist you
Cheers
1 Like
The sample file I shared will direct you to the site in the picture. The meaning of the part I underlined in red is 271 results found. In other words, the extract table data activity needs to write 271 prices to excel. numbers ending with tl indicate the price.
In short, the amount of results on the website and the amount of rows written in excel should be the same.
sample.zip (491.9 KB)
