How To Filter Multiple Rows In Excel

Hi,

I want to filter “Rishi” in Name Column but when i was filtering the whole table got filtered instead of Name Column.

For reference i was attached snapshot below.
Filter

Thanks,
Rishi

Hi @Rishik_Chowdary

Have try with Filter Data Table Activity

In this case Filter the Name Column contains Rishi. It will take particular row values which contains Rishi

image

Regards
Gokul

Thanks For Ur Reply @Gokul001

But when i was filtering “Rishi” It has to filter Only Rishi (Name and Age)

Solution Could Be
Name Age Name1 Age1 Name2 Age2
Rishi 22 Anbu 26 lee 30
Null Null MAni 27 Adam 32

Hope you understand…!! Thanks

image

HI @Rishik_Chowdary

Try to use Output Columns in filter DataTable activity and Filter rows that contain in the above post

Have a look into the screenshot

image

Regards
Gokul

1 Like

Hi @Rishik_Chowdary ,

Is this what you were looking for?

image

(From row In dt_sampleData.AsEnumerable()
Let chk = dt_sampleData.AsEnumerable.Where(Function(w) row("Name").ToString.Trim.ToLower.Equals("rishi")).ToArray()
Let ra = New Object(){
	If(chk.Count()>0, chk.First().Item("Name").ToString.Trim,"Null"),
	If(chk.Count()>0, chk.First().Item("Age").ToString.Trim,"Null"),
	row(2),
	row(3),
	row(4),
	row(5)}
Select dt_result.Rows.Add(ra)).CopyToDataTable()

CheckForValue.xaml (8.1 KB)

This is the one for actual null values:

image

(From row In dt_sampleData.AsEnumerable()
Let chk = dt_sampleData.AsEnumerable.Where(Function(w) row("Name").ToString.Trim.ToLower.Equals("rishi")).ToArray()
Let ra = New Object(){
	If(chk.Count()>0, chk.First().Item("Name").ToString.Trim,""),
	If(chk.Count()>0, chk.First().Item("Age").ToString.Trim,"")
	}.Concat(row.ItemArray.Skip(2)).ToArray()
Select dt_result.Rows.Add(ra)).CopyToDataTable()

CheckForValue_v1.xaml (8.1 KB)

Kind Regards,
Ashwin A.K

Try using “Lookup range” activity, provide sheet name and give your input name to check, create output variable for it. It will give row index of your searched value. After that you can read age based on that output index.

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