おはようございます
UiPath Studio 2022.4.3EnterPrise Editionユーザです。
下記２つの構文で同じ内容のdt_1が抽出できたため、少なくともデータの抽出をする際には、SelectとWhereは同じように使ってよいという認識ですが、合っていますでしょうか？
dt_1=dt_log3.AsEnumerable().Select(Function(c) c("Status").ToString() = "〇").GroupBy(Function(r) r("Date").ToString()).SelectMany(Function(g) g).CopyToDataTable()
dt_1=dt_log3.AsEnumerable().Where(Function(c) c("Status").ToString() = "〇").GroupBy(Function(r) r("Date").ToString()).SelectMany(Function(g) g).CopyToDataTable()
最初の式は静的エラーになると思いますので、結果が出力されることはないと思います。
ただしく何らかの出力を得られたのであれば、今一度式を確認された方が良いと思います。
Select is used to get a particular item from a given row
Where is used to filter the row based on a certain confition
Both are not same…
May be the select you are referring to might be the datatable select without AsEnumerable…then the functionality of where with AsEnumerable and select without asenumerable is same…
In current given syntax…the first suntax would fail as the select statement you have would pass true or false to the next where condition and as you are trying to use as row it would throw error
Cheers
失礼しました。掲載する構文を間違えました。
下記２つの構文を実行したら、dt_1に同じ値が取得されたため、SelectとWhereのどこが違うんだろうと思った次第です。
dt_1=dt_log3.AsEnumerable.Select(Function(c) c("Status").ToString = "〇").CopyToDatatable
dt_1=dt_log3.AsEnumerable.Where(Function(c) c("Status").ToString = "〇").CopyToDatatable
Sorry, but I referred unintended syntax.
Since I found the follwing two syntaxes resulted the same dt_1, I wanted to understand the difference of Select and Where.
dt_1=dt_log3.AsEnumerable.Select(Function(c) c("Status").ToString = "〇").CopyToDatatable
dt_1=dt_log3.AsEnumerable.Where(Function(c) c("Status").ToString = "〇").CopyToDatatable
I believe you have not tried the syntax at all…as already mentioned select is different…select will get what you write inside it and where will filter
by default if you try with select you would get an error
cheers
