Error for Filter DataTable

[I_am_Praj]

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.

[Anil_G (Anil Gorthi)]

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

[Gokul001 (Gokul Balaji)]

Hi @I_am_Praj

Instead of Column Name try with Column Index

Regards
Gokul

[I_am_Praj]

I have given Column names same as extract one

[I_am_Praj]

Then what name should be in Extract data?

[Gokul001 (Gokul Balaji)]

Hi @I_am_Praj

You can Put 0 instead of Interface

Regards
Gokul

[Anil_G (Anil Gorthi)]

@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

[Rahul_Unnikrishnan]

Hello @I_am_Praj

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

Thanks

[I_am_Praj]

@Rahul_Unnikrishnan @Anil_G @Gokul001

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

[Gokul001 (Gokul Balaji)]

Can you share the error screenshot? @I_am_Praj

Try to Remove the Double Quotation in the Column

Regards
Gokul

[I_am_Praj]

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

[Anil_G (Anil Gorthi)]

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

[I_am_Praj]

i have tried this too…

[Gokul001 (Gokul Balaji)]

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

[I_am_Praj]

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.

.

BR,
Praj

[Gokul001 (Gokul Balaji)]

Hi @I_am_Praj

You can use Message box after the Extract Table Date activity

InterfaceDataTable.Rows.Count

Regards
Gokul

[I_am_Praj]

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

[Anil_G (Anil Gorthi)]

Hi @I_am_Praj

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

Cheers

[Gokul001 (Gokul Balaji)]

@I_am_Praj

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

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

[ahmad.sultan]

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.