Error in Filter Data Table

Help
1

Hi Guys,

Am facing the below error could someone please help me while filtering a particular value. I have unchecked add headers in read range activity but even if i select the add headers am getting the same error. Please help

image

1 Like
2

Can you share a screenshot to show how you’ve configured the filter datatable activity

3

Hi Athira, Below screenshot for your reference

image
image803×562 12.5 KB

image
image601×580 16.8 KB

image
image461×569 11.5 KB

4

Hi @Jagadesh2494

can you share the excel file?

cheers :smiley:
Happy learning :smiley:

1 Like
5

@Jagadesh2494 - pls try below

  • read excel with headers
  • use output datatable actviity and pass the datatable as input and assign to a string variable like strDtTxt.
  • use log message activity - log the strDtTxt (it will help you to findout the column names are available in datatable)
  • based on the log message columns → use filter datatable activity to filter the records…
1 Like