I want to remove duplicate row values on the basis of RUN ID column form excel sheet

Hi
hope this expression would help you resolve this
dt = dt.Asenumerable().Groupby(Function(a) a.Field(of string)(‚ÄúRUN ID‚ÄĚ).ToString).Select(Function(b) b.First()).Copytodatatable()

where dt is your datatable
and if you are not getting asenumerable then kindly have a view on this

Cheers @Sachin_Jadhav

2 Likes

@Sachin_Jadhav,

Check this component,

1 Like

getting below error

1 Like

may i know at which activity we are getting this
Cheers @Sachin_Jadhav

Assign activity

1 Like

FIne
is the RUN ID column is of type string
if so kindly remove that .ToString in the expression and try once
if not kindly share the xaml if possible

Cheers @Sachin_Jadhav

This activity working.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.