How to counting data string in data excel in uipath studio X?

[bayu.herlambang]

In column result:
OK : 6 Data
NOT : 3 Data

for result in new sheet
How to Counting data from column result?

for sample result:

[Yoichi]

Hi,

Can you try the following sample?

dtResult = dt.AsEnumerable.GroupBy(Function(r) r("Result").ToString).Select(Function(g) dtResult.LoadDataRow({g.Key,g.Count.ToString+" Data"},False)).CopyToDataTable

Sample
Sample20240222-3a.zip (7.5 KB)

Regards,

[Yoichi]

This also works in StudioX as the following.

NewBlankTask20240222-1a.zip (54.7 KB)

[bayu.herlambang]

Thank Mr. Yoichi

Koniciwa

because after add activity:

[bayu.herlambang]

For my project
JoinDataTable.zip (185.3 KB)

[Yoichi]

Because you already use SingleExcelProcessScope. In this case, it’s unnecesary to use it there.

[bayu.herlambang]

Thanks, where do I put the activity?

[Yoichi]

As there is SingleExcelProcessScope on the most outer sequence, it is no necessary to use it again.

[bayu.herlambang]

For the activities below, do you put excel aplication scope?

[bayu.herlambang]

Thank you very much, it’s already running on the project I made Mr. Yoichi.
ありがとうございます。すでに僕のプロジェクトで動いています。