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.
Thanks,
Rishi
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.
Thanks,
Rishi
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
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
Try to use Output Columns in filter DataTable activity and Filter rows that contain in the above post
Have a look into the screenshot
Regards
Gokul
Hi @Rishik_Chowdary ,
Is this what you were looking for?
(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:
(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.