Skip to main content
Ground Control | Tier 1
September 20, 2022
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.

  • September 20, 2022
  • 1 reply
  • 93 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

    Tamil Arasu10
    Most Valuable Pathfinder
    Most Valuable Pathfinder
    September 20, 2022

    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!

    _Tamil_