FilterDataTable-the value for argument 'Column Name' is not set or is invalid

[sharu_priya]

HI Folks,

Here, i need to filter only the LineNumber which has the value 1.

I checked the spaces also. Still same error

Attaching excel for you reference

Regards,
Sharu
PO_Details.xlsx (9.3 KB)

[Gokul_Jayakumar (Gokul Jai)]

Hello @sharu_priya
You can use the Index number instead of Column Name
Use 1 instead of “LineNumber”
Also, there is a Space at end of column Name. Remove it and check the process.

[vishal.kp (vishal)]

Hi @sharu_priya ,

The column name LineNumber has an space at the end, hence it is throwing a error of column not found.

After you read the datatable, loop through the column names and trim like shown below:

item.columnname=item.columnname.trim

Regards,

[sharu_priya]

@vishal.kp

item.columnname

Thank you.

But getting the error has “Option Strict on disallows late binding”

What should be the type of argument in for each?

[vishal.kp (vishal)]

@sharu_priya ,

Regards,

[sharu_priya]

@vishal.kp and @Gokul_Jayakumar .

Thanks for your suggestions yaar. It worked.

But when i use it in write range, i am not getting the output, did not throw the error though.

I am not sure it is filtered or not

[vishal.kp (vishal)]

@sharu_priya ,

Can you put a break point on the write range activity, run the process in debug mode and check the filtered data table value?

Regards,

[sharu_priya]

Sure

[vishal.kp (vishal)]

@sharu_priya ,

Check this workflow, i have tried the same steps and was able to get the desired output:

Sp.xaml (8.4 KB)

Regards,

[Gokul_Jayakumar (Gokul Jai)]

@sharu_priya
Line number is the Integer format.
So you can provide 1 instead of “1” with “=” Filter Operation.

[sharu_priya]

Hi Vishal,

I used your workflow only, but i am not getting that.

[sharu_priya]

@vishal.kp and @Gokul_Jayakumar .

Thanks much for your time.

Instead of contains i tried giving “=” since it is an integer

[vishal.kp (vishal)]

@sharu_priya

In the filter condition, keep just 1 and try instead of "1"

Regards,

[sharu_priya]

Thanks much

[sharu_priya]

@vishal.kp and @Gokul_Jayakumar

How to write the filtered data in the same sheet by removing the other values in the datatable?

[Gokul_Jayakumar (Gokul Jai)]

@sharu_priya , Use Delete Range Activity and Pass the range to delete the values, then write into it.