How can i modify Datatable in foreach loop? in C#

[Sa_Ge]

I’m trying to delete duplicate column in Product and other blank data in Price column and repeat the process but it seems that datable needs to modify constantly but uipath wouldn’t let me is there any other way
DeleteBlankdata.zip (111.2 KB)

[THIRU_NANI (NaNi)]

Hi!

Have a view on this thread

How to remove rows with duplicate columns

Hello @carlor you can use linq here use this code in an Assign Activity (From roww In DT.AsEnumerable() Group By id=New With {key .i=roww.item("col1"),key .d=roww.item("col2")} Into gg=Group Select gg(0)).copytodatatable it’ll group the two columns in your case col1 and col2 the workflow should look like this [Group%20by%20calor]

Regards,
NaNi

[Sa_Ge]

sorry about my naivety but i don’t quit understand the linq code can u please kindly share work flow if you don’t mind

[THIRU_NANI (NaNi)]

Just follow the below step!

newDT = inputDT.DefaultView.ToTable(True,“col1”,“col2”)

Regards,
NaNi

[Sa_Ge]

this resolve first column but for the second col is to remove null there is no duplicate

[THIRU_NANI (NaNi)]

Can you show me the data which is available in excel?

for removing the empty rows from a excel you can use filter data table.

column mention column name and operation is is Empty

Regards,
NaNi

[Sa_Ge]

TestData2.xlsx (8.6 KB)

[kadiravan_kalidoss (Kadiravan K)]

Hi @Sa_Ge,

xaml:
RemoveDuplicate_Null.xaml (6.6 KB)
sample input & output:
MouseData.xlsx (9.9 KB)

Thanks!

[pavithra_pavi]

Hey @Sa_Ge ,

Below XAML will give you filtered data which doesn’t have duplicate and the Null.

RemoveDuplicateAndNull.zip (14.0 KB)

Let me know if you face any issue

[Sa_Ge]

I didn’t notice it could use that way thanks a lot. it helps me greatly.

[Sa_Ge]

Thanks a lot for helping me out I didn’t notice it work that way appreciated it.

[pavithra_pavi]

@Sa_Ge , happy to help😌