Extracted Data seperation in two categories by %?

I have extracted data from the Flipkart website of sports shoes its name, Price and Discount but I want separate Data by Discount in two categories below 50% discount data in one sheet and above 50% discount data in the other sheet. How to do this. Please help.

Hi @Akshay_patil,

You can use Filter data table activity or DT.Select(ColumnName = ‘Value’) to filter the datable and use write range to write it in an excel sheet.

Hope this will solve your problem. Happy Automation :innocent:

1 Like


Try below select queries.

       DT1 = inputDT.Select("Discount <= '50'").CopyToDataTable 
       DT2 = inputDT.Select("Discount > '50'").CopyToDataTable