Im trying to learn Select filter on datatable… due to lots of IF else statements I want to try Select filter…
I try to create something but look like im missing some thing…
Check my try to select filter …
im trying to get all unique ID first… Assign act.
UniqueDT = dt1.DefaultView.ToTable(true,“ID”)
then i have created a for each loop on UniqueDT…
Urow = UniqueDT
within this for each loop i start with an Assign activity again… which can show me the unique id which has same value–
UniqueValue = dt1.Select("[ID] = ‘"+row(“Column1”).ToString+"’").CopyToDataTable
for each loop again on UniqueValue
Uvrow = UniqueValue
with this I create a message box with value
And all this give me value one by one and its not that I want…
I want its show me ID 2 value same time means when it comes to ID 2 … it should show both 500 + 1000
and the same 2 row value on ID 4 = 700+900
can someone tell where/what I do wrong?