Question

I have extracted data into excel sheet, now I want to separate the data from excel sheet based on its date so anyone can help me which action can be used.

  • 20 September 2022
  • 1 reply
  • 7 views

I have extracted data into excel sheet, now I want to separate the data from excel sheet based on its date so anyone can help me which action can be used.

1 reply

Userlevel 3
Badge +7

Hi @santhoshi kukkadapu​ ,

 

You can use the Excel Advanced Package to achieve this.

 

  • You have to read data from Excel using Loop or store the data into Table
  • 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!

Reply