Filter Data table with specific column

Help
1

Hi, How can i use filter data table activity but the column name is not in first row.
For ex:

image
image1049×137 5.55 KB

The highlighted column

Thanks!

2

IF you read in the datatable from row 7 onwards you can make that your header row and then filter.

3

hi,

dt.Rows(5).ItemArray(12).ToString,this is my code,
it return the column i wanted but once it run,
this kind of error return:
image

image
image1188×567 44 KB

4

hi,
you can see my reply below :slight_smile:

5

In read range range activity mention the range as “A7” buddy so that it starts to read from A7 and add headers option enabled will take the first row as headers buddy…by that way you can access the column names and apply filter datatable buddy

Cheers

6

Buddy the column name PMT MTHD but you have mentioned in filter datatable column as just pmt
thats why buddy @mashy2

And i understood that you have passed the variable as pmt but it should be of type datacolumn…is that in that type buddy…?
@mashy2

7

@Palaniyappan elaborated what I said but you need to read the datatable in exactly as you want it.

Or amend the datatable once you read the whole excel in and add your headers

8

Hi,
The column that i want to read is: Pmt Mthd.
I use assign activity for pmt =dt.Rows(5).ItemArray(12).ToString to get value of Pmt Mthd as i shown in screenshot.
Then i assign back the pmt in filter data table activity and got error return.
Im not sure where you see PMT MTHD in the screenshot i highlighted :slight_smile:

9

Alright buddy @mashy2 that pmt variable must be type datacolumn and not string and you cannot pass a cell value like this dt.Rows(5).ItemArray(12).ToString for column field and it should be like this

cgls_dt.Columns(12)

in the column field of filter datatable buddy

10

thank buddy for your time to reply me .

Got any idea why error still return?

image
image1188×595 51.9 KB

11

Buddy @mashy2 better dont use any variable. Straight away go to filterwizard pass the cpls_dt as input datatable and in column field enter the column name of that column , just name, no quotes around…or enter as cpls_dt.Columns(12)…

Try this buddy lets try to sort this out

Cheers

12

thanks so much buddy! :slight_smile: :fist_left:

13

Thats great, cheers buddy keep going

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.