I want to remove row that includes duplicated cell value, in datatable

[hoseongwon (호성 원)]

Hello.

name color
apple red
apple red
apple red
grape blue
grape blue
blueberry blue

to

name color
apple red
grape blue
blueberry blue

What activity or vb term should I have to use?
please let me know.

[Anil_G (Anil Gorthi)]

@hoseongwon

You can try using this in assign…dt is the datatble

dt = dt.AsEnumerable.Distinct.CopyToDatatable

Or can use as below

dt = dt.DefaultView.ToTable(True,"Name","Color")

cheers

[Jithesh_R]

Hey @hoseongwon ,

Try,
OutputDT = InputDT.DefaultView.ToTable(true,“name”,“color”)

Regards,

[hoseongwon (호성 원)]

dt.defaultview worked Thank you so much!