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.
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.
Userlevel 6
+15
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!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.