Filter Blank rows

[nidhi.kowalli]

Hello people,

Basically there are 3 columns in an excel sheet.
‘column 1’ and ‘column 2’ contain data. Column 3 contains some blank rows.
I need to filter “Col3” and use them for further process.

Tried with “Filter datatable activity” . Did not go well.

Any other way for this? Please suggest

Regards,
Nidhi K

[ppr (Peter)]

geting the col3 nonblanks
(From d in YourDataTableVar.AsEnumerable
Where Not (isNothing(d(“Col3”)) OrElse String.IsNullorEmpty(d(“Col3”).ToString.trim))
Select d).CopyToDataTable

geting the col3 blanks
(From d in YourDataTableVar.AsEnumerable
Where isNothing(d(“Col3”)) OrElse String.IsNullorEmpty(d(“Col3”).toString.trim)
Select d).CopyToDataTable

we would use it within assign activity

[Palaniyappan (Forum Leader)]

Hi
Hope this would help you resolve this

Provided with a xaml workflow

Filter datatable by blanks

hey @NiranjanKN, I don’t get what you’re saying, could you please elaborate more.

Cheers @nidhi.kowalli

[NIVED_NAMBIAR (NIVED N)]

Try this

dt1.AsEnumerable().Where(Function (r) r(“column3”).ToString.Trim.Equals(“”)). CopyToDataTable

Regards

Nived N

[nidhi.kowalli]

@ppr

geting the col3 blanks
(From d in YourDataTableVar.AsEnumerable
Where isNothing(d(“Col3”)) OrElse String.IsNullorEmpty(d(“Col3”).trim)
Select d).CopyToDataTable

What is “d” you are referring here?

[ppr (Peter)]

it is acting like a carname to the looped datarow
Also have a look here:

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operators Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start # All Operato…

[nidhi.kowalli]

Hey @NIVED_NAMBIAR

Logic you gave works fine as filter.
Its filtering blank values properly, but the thing is , its not removing the rest of the data.

I mean,
finally after applying logic, “Columm 3” is filtering by blank values and displayed at top of sheet, Rest of the data is appending.
I dont need that . How do I remove those rows?

[ppr (Peter)]

may we ask you to share with us what you have implemented so far. So we can guide you to finalize the case. Thanks

[nidhi.kowalli]

@ppr @Palaniyappan @NIVED_NAMBIAR

Thank you guys!
I got the Output Properly!

Regards,
Nidhi k

[ppr (Peter)]

Perfect. May we ask you to close the topic by marking the solving post as solution. So others can benefit from it. Thanks

[Aleem_Khan (crazy bot)]

his is showing error

[ppr (Peter)]

try following (sometimes compiler caches are causing this issue)

(From d in YourDataTableVar.AsEnumerable
Where isNothing(d(“Col3”)) OrElse String.IsNullorEmpty(d(“Col3”).toString.trim)
Select r=d).CopyToDataTable

[Aleem_Khan (crazy bot)]

@ppr

(From d in YourDataTableVar.AsEnumerable
Where isNothing(d(“Col3”)) OrElse String.IsNullorEmpty(d(“Col3”).trim)
Select r=d).CopyToDataTable

not working

[ppr (Peter)]

@Aleem_Khan

not working

only details will help us. What is not working?

[Aleem_Khan (crazy bot)]

[ppr (Peter)]

check updated statement

[farhaan.khan86 (Farhaan Khan)]

try below line of code

DT1.Select(“[Col3]=‘’” ).CopyToDataTable