Filtering Excel rows

[thima (Himabindu)]

Hi All,
I have input data i want to filter upstream and downstream applications.
Please help me

Regards,
Hima

[Pramod_Nannaka]

DT.Asenumerable.where(Function(x) x(Column1).Tostring =“upstream Application Dependencies(Asset Manager)” or x(Column1).Tostring=“Downstream Application Dependencies(Asset Manager)”).CopyTodatatable

[RajKumar_DC (RajKumar Durai)]

Hi @thima,

Use Filter data table with below mentioned Configure

Input

Output

Filter Data table

Xaml
Sequence2.xaml (8.4 KB)

Thanks,
Rajkumar

[Edwin_Barahona]

Hi @thima,

If you wish to filter directly in the excel document, you could use the Excel Filter activity

Filter

[thima (Himabindu)]

This file is not able to open

[Gokul001 (Gokul Balaji)]

HI @thima

Check out this XAML file

FilterStartWith.xaml (6.9 KB)

Regards
Gokul

[thima (Himabindu)]

This is giving output of below.

Iam not getting application names below upstream application names also need to filter

[Gokul001 (Gokul Balaji)]

What do you mean by application name @thima

You are talk about the Column Headers?

If yes, You can Disable the Properties of Ass Header in the Write Range activity