Data table filter not working

Help Studio
, ,
1

I am trying to filter a data table by date which is in a column, I have set a variable to be used in the data table filter but I am getting an index not set error (per screenshot you can see that it is)…

image
image1902×986 129 KB

2

Hi @Nathan_Betters1

This error occurred because there is no 3rd column in the ‘ExtractDataTable’ data table.
If you want to filter the 2nd column then pass the index as 1.

Index 0 - Column 1
Index 1 - Column 2
Index 2 - Column 3

Thanks
John

3

There is though, I also write the table to excel and there’s 7 total columns but the first 3 are empty

4

If possible, can you share the screenshot of excel file with columns and few rows

5

Please share your sample input file here…

Regards

Sreejith S S

6

Hi @Nathan_Betters1,

Please try to give column’s name here. Like “ExamleColumn”.

Regards

7

Hello @Nathan_Betters1

After extracting the table just try to print the below.

dt.Columns.Count.ToString

dt is your datatable. Also, you need to add the index of the column properly for the correct column.

Thanks

8

@Nathan_Betters1
Kindly check your read range, and try to pass the column name instead of the index and check it. If possible share some sample inputs, it will help us to provide a better solution for you.

9

Can’t pass a column name, if I do not know them, when it prints to excel there is no names on the columns

10

@Nathan_Betters1
Kindly check the image with your activity.
image
image

Place the Message box below the read range
ExtractdataTable.rows.count.tostring. it will print the value of rows count in Data Table