Error in Filter Data Table

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


1 Like

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

Hi Athira, Below screenshot for your reference

Hi @Jagadesh2494

can you share the excel file?

cheers :smiley:
Happy learning :smiley:

1 Like

@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