Filter Data table activity gives error

Help Studio
, ,
1

Filter Data Table: the value for argument ‘Column Name’ is not set or is invalid.

Hello all, I want that those column name start with NAR are to be copied in new sheet of same excel in A1 Cell.

2

@dhanashree22

Filter Data Table works only if you gave the column and the rows to filter by giving the condition

If you can provide more details like by sharing the sample input and output required, screenshots that will help better to understand your issue

Thanks

3

Doc1.docx (93.0 KB)

4

@dhanashree22

If you want to check the column Names then

  1. Read Range to read the excel file and create a variable for Output as a Datatable
  2. Place a For Each activity in that write as DtVariable.Columns
  3. Inside that put a If condition and place Item.Startswith(“NAR”) then you can keep your logic

Hope this may help you

Thanks

5

Hi @dhanashree22 ,

  1. Open excel scope and read the excel file and save the output to datatable.

    image
    image1026×349 15.1 KB

  2. Outside the excelscope call the filer datatable activity and just give the column name as it is in double quotes.

image
image940×530 24.8 KB

6

how to put dtvarible.column in for each activity .please give some screenshot of this

7

@dhanashree22

image

Thanks

8

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