Unable To filter the data in filter datatable activity

Help Activities
, ,
#1

Hi All,

Good morning all.
I am trying to filter a column using filter data table but I am unable to filter by column index\name (1 is the column name).
out of 3 values (1,2,4) I just wanna filter with the value “1”.
Please help me to resolve the same.

Screenshot (70)
Screenshot (70)1366×768 74.6 KB

Processing: Copy of GL batch dump - pos cash.xlsm…
Exceldata.xlsx (1.8 MB)
I am trying to filter column “Q”

Best Regards,
Naveen Kumar S

#2

Hi @HeartCatcher

Try this XAML file.

Main.xaml (6.0 KB)

Hope it will work.

Regards
Gokul

#3

Hi!

You can use this condition in Filter Data Table activity after you read the sheet:

image

Hope it helps!

#4

@Gokul001,
thanks for your reply, I tried as you suggested but I am getting an error like “Column Name is Invalid”.

Regards,
Naveen S

#5

@Catalina_Rs
thanks for your reply, I tried as you suggested but I am getting an error like “Column Name is Invalid”.

Regards,
Naveen S

#6

Hi @HeartCatcher

Could you please Run that flow its working good?
Could you please check the Column Name?

Can you check it
Filter DT.zip (3.3 MB)

Regards
Gokul

#7

The column that you want to filter isn’t named “1”?

If you don’t want to use the column name, and if your column is always on that position (“Q”), you can use this condition:

image

#8

Hi @HeartCatcher

Please use Select method to filter the Values with 1

Datatable.Select("[1]=‘1’").CopyToDatatable

Refer the xaml below.

Filter_Datatable.xaml (5.4 KB)

Regards

#9

Hi,

Actually its a xlsm file not excel file I will get a output file after running the macros then I am trying to do the filter.

#10

Hi @Gokul001,

Its working fine if I use in excel format but when I use the Macro output file xlsm it is giving an error like column not found

#11

Hi @HeartCatcher

Use excel appliction scope to read the excelfile and get Dt and Filter based on your condition.

Enable a macro setting in your excel application

Regards

#12

Hi @HeartCatcher

you can change the Excel Application scope Properties and try to run the process (Refer the Screenshot)

image
image1041×326 19.7 KB

Regards
Gokul