Error for Filter DataTable

Help Studio
1

interface
interface1194×284 11.5 KB

Hello All,

Have a good day !

I’m getting below error -

Filter Data Table: the value for argument ‘Column Name’ is not set or is invalid.

However -

  • I have checked add header of datatable

  • Columns are also correctly mentioned in filter data table.

Please help me to resolve this error.

2

Hi @I_am_Praj

Can you show what you did inside configure please. As per error the column name is wrong or is not given

Name should exactly match with what you have .

Cheers

3

Hi @I_am_Praj

Instead of Column Name try with Column Index

Regards
Gokul

4

extract
extract912×101 3.57 KB

Filterdata
I have given Column names same as extract one

5

Then what name should be in Extract data?

6

Hi @I_am_Praj

You can Put 0 instead of Interface

Regards
Gokul

7

@I_am_Praj

Can you check if there are spaces in column name and also you can as well use column number as 0 for first column

Run in debug and from locals panel please check the column name

Cheers

8

Hello @I_am_Praj

You can do as below. Instead of column name, you can use the index as in the screenshot.

image

Thanks

9

@Rahul_Unnikrishnan @Anil_G @Gokul001

I tried to use 0 instead of column name but it didn’t worked

filtertable1
filtertable1486×502 11.5 KB

10

Can you share the error screenshot? @I_am_Praj

Try to Remove the Double Quotation in the Column

image

Regards
Gokul

11

This is the error - Filter Data Table: the value for argument ‘ColumnIndex’ is not set or is invalid.

12

Hi @I_am_Praj

If you are using index then directly give 0 do not give double quotes arouud it. Please remove double quotes and the issue should be resolved

Cheers

13

i have tried this too… :neutral_face:

14

HI @I_am_Praj

Can you Print the Dt in the excel file and check it.

Use Message box activity to get the count of the data table

Dt.Rows.Count

And share the screenshot

Regards
Gokul

15

Hello @Gokul001

Attached is this workflow which have created.where should i use message box?
I’m reading the values from read rang then extract the value with the help of extract data table & then used filter activity.

image
image396×554 14.7 KB
.

BR,
Praj

16

Hi @I_am_Praj

You can use Message box after the Extract Table Date activity

InterfaceDataTable.Rows.Count

Regards
Gokul

17

Hello @Gokul001 Getting only “0” count in message box.
Note - also not getting output of extract table in immediate window.

18

Hi @I_am_Praj

That means your input datatable is empty…please check if you are reading the data properly

Cheers

19

Your Data table is empty Right? Can you extract the Data correctly and check it. Issue with the extraction part.

Here While extracting the You getting count as Zero athat why you did not get the column name.

Hope this will helps

Regards
Gokul

1 Like
20

Hi @I_am_Praj ,

Place an IF condition: InterfaceDataTable.Rows.Count>0

If True, then use Filter Data Table activity. It will solve your issue.

1 Like