Delete Entier Row

[MD_Farhan1 (MD Farhan)]

Hi,
I have 4 column (Name,Service,Salary,DOB).Now check Service Column row is empty Delete entier row.(entier row means name ,service, salary, DOB)

Regards

[lrtetala (Lakshman Reddy)]

Hi @MD_Farhan1

Use Filter DataTable activity

Cheers!!

[mkankatala (Mahesh Kankatala)]

Hi @MD_Farhan1

Can you try this linq query:

(From row In dtInput.AsEnumerable()
           Where Not String.IsNullOrEmpty(row.Field(Of String)("Service"))
           Select row).CopyToDataTable

Regards

[pravallikapaluri]

Hi @MD_Farhan1
Try using Filter datatable activity

[rlgandu (Rajyalakshmi Gandu)]

@MD_Farhan1

DT.AsEnumerable() _
    .Where(Function(row) Not String.IsNullOrWhiteSpace(row.Field(Of String)("Service"))) _
    .CopyToDataTable()