Filtering Excel rows

Help Studio
, ,
1

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

image
image1366×245 16.6 KB

Regards,
Hima

2

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

3

Hi @thima,

Use Filter data table with below mentioned Configure

Input
image

Output
image

Filter Data table
image

Xaml
Sequence2.xaml (8.4 KB)

Thanks,
Rajkumar

4

Hi @thima,

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

5

This file is not able to open

6

HI @thima

Check out this XAML file

FilterStartWith.xaml (6.9 KB)

Regards
Gokul

7

This is giving output of below.

image
image916×123 3.28 KB

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

8

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

image
image879×194 7.76 KB