Skip to main content
Question

I have extracted data table into excel sheet from a website, now I want to separate the data from excel sheet based on its date. So anyone can help me which action can be used for the extraction of data. I am struck with this. can anyone help me.

  • September 20, 2022
  • 1 reply
  • 92 views

I have extracted data table into excel sheet from a website, now I want to separate the data from excel sheet based on its date. So anyone can help me which action can be used for the extraction of data. I am struck with this. can anyone help me.

1 reply

Tamil Arasu10
Most Valuable Pathfinder
Forum|alt.badge.img+18
  • Most Valuable Pathfinder
  • September 20, 2022

Hi @Nadella Santhan​ ,

 

You can use the Excel Advanced Package to achieve this.

 

  • You have to read data from Excel using Loop.
  • Use the If condition, for a required field value (date) to separate the data from excel
  • OR, Use Filter Table Using Filter table action to separate the data from excel

 

Thanks!