Filter Datatable "Name Column is not valid

Help Studio
1

Good morning,
For 2 days I have had my datatable filter not valid every other time even though I haven’t changed anything and the data is the same.

In terms of data extraction, I

extract
extract563×737 56.2 KB

have the column names. I don’t compensate
My filter
filter
filter1350×786 116 KB

2

@Lorant

May be there is a space in the column name pres…check the same

cheers

3

@Lorant,

It seems problem in input. Check the data being extracted have the same column names o r are they updated.

Thanks,
Ashok :slight_smile:

4

1 pls validate the data extracted
2 Remove extra space in the data
3 convert the source and distance column data in lower case and check

5

Thanks for your feedback.
I open an application, I do a search with an identifier and I arrive on this page.

ene
ene1219×838 53.4 KB

then I click on the Business History button to open the data and I use extract data base. I get two columns and modify the column names…
enedi
enedi868×774 50.2 KB

I can see that in each different page the column names are the same. (no space, etc…) I don’t see why.
I use database filter to retrieve columns which contain F120, F100 etc.
But at the filter level it gives me invalid column names. However when I check I have the same name (without space, capital letter, etc.)

6
  • Set a breakpoint on the filter Data Table Activity
  • Debug the flow and get paused by the breakpoint
  • use the immediate panel and inspect the extracted Datatable e.g.
    YourDataTableVar.Columns

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

UPD1 - additional suggestion

  • we dont know if PRES, PRES… … colname is displayed different e.g. due smaller size…
    But for the filter DataTable you can also try using the column index (second column = 1, as it is 0-based index)
7

@Lorant,

If you are getting the data correct and only concern is the column name and column index are always same.

Get the column names for every table extract and then rename to the desired names.

https://www.google.com/search?q=rename+data+table+name+uipath&rlz=1C1GCEB_enIN1018IN1018&oq=rename+data+table+name+uipath&gs_lcrp=EgZjaHJvbWUyBggAEEUYOTIICAEQABgWGB4yCggCEAAYgAQYogTSAQkxMDE4M2owajeoAgCwAgA&sourceid=chrome&ie=UTF-8

Thanks,
Ashok :slight_smile: