Filter Excel based on Column

[Vincent_Nuestro]

How to filter excel based on Column Where Column Name is a Dynamic Data.

Get all data based on “Manager Name” Column and write it in Excel

Thank you in advance

• Vincent

[Gokul001 (Gokul Balaji)]

Hi @Vincent_Nuestro

Try to use Filter Datatable Activity.

Based on the requirement you can add multiple manager name by click (+)

Regards
Gokul

[Vincent_Nuestro]

hi @Gokul001

The “value” in column is a dynamic data, it always change. and sometimes it is more than 5 to 10 records (“Manager Name”)

is there any other way to filter it out dynamically?

[Gokul001 (Gokul Balaji)]

Hi @Vincent_Nuestro

Refer to the below thread

How to filter the excel row with dynamic key words?

Hi @Dorothy_lee , Follow below steps. [image] Read KeyWord Excel into one datatable(KeyWordDT) and convert it to Array of Keywords as below KeyWordArr=KeyWordDT.AsEnumerable().Select(Function (a) a.Field(of string)("Column Name").ToString).ToArray Read target excel into Datatable (InputDT). Assign ResDT=InputDT.Clone Use below expression in assign activity. ResDt=(From row in InputDT.Asenumerable Where KeyWordArr.AsEnumerable.Where(Function(x) row("ColName").ToString.Trim.Conta…

Regards
Gokul

[Vincent_Nuestro]

Hi @Gokul001

I found same Problem here

Filter records based on dynamic column values

Hi ,i have a tble like below .i want to filter to filter the records based on column “department” which is dynamic,where the values under that column may increase. [image] After filtering based on columns want to write in different excels. can anyone help me on this. Thanks

and trying the Solution provided

I don’t know what variable type in the first Code that he provided