Filter wizard column name

[Nenna_Anya]

I have a filter datable. I am getting the error the column name is invalid. Looks like I need to convert the column name to something else like an index or something. Thanks

[raja.arslankhan (Raja Muhammad Arslan khan)]

Hi @Nenna_Anya
please show me output Columns as well

There is possibility you have space end of columns or start of columns. so please check this one.

[Sanjit_Pal]

Hello @Nenna_Anya,

There might be the extra space at the end or the starting of the column name in the excel file, check if it is there remove the spaces and try and also it’s case sensitive value so better to use the same whatever is there in the excel.

Thanks,
Sanjit

[Nenna_Anya]

There is no spaces. I need to know how to reference the column name with an index or something. I have tried row(2).Tostring and it is not valid.

[raja.arslankhan (Raja Muhammad Arslan khan)]

Hi @Nenna_Anya
please try this one
ExtractDataTable.Columns(yourcolumn index).ColumnName

[Nenna_Anya]

Thank you, that worked…

[raja.arslankhan (Raja Muhammad Arslan khan)]

Welcome @Nenna_Anya please mark it as a solution so that other can get help from it.

Happy Automation

[postwick (Paul)]

You should look at the datatable and understand why it says your column name doesn’t exist. It must mean the column name isn’t what you think it is. Use a Log Message to output ExtractDataTable.Columns(yourcolumn index).ColumnName to see what the real column name is. Or use Debug mode.