Skip to main content
Cadet | Tier 2
February 23, 2022
Question

I have a huge table in excel (around 20,000 rows). I am using query to extract the required information. I have a doubt in doing that. Out of those data I have 300 unique customer names. Will I be able to extract based on a list of cutomer names.

  • February 23, 2022
  • 1 reply
  • 59 views

I need information for Customer A, Customer B, and Customer C alone. Is it possible to extract in this way ? Also if my list is dynamically changing, How do I do that.

 

Thanks in Advance

    1 reply

    Automation Anywhere Team
    May 22, 2022

    Hello @Adityaganesh Srinivasan​ 

     

    Thank you for writing us at the AA forum.

     

    You can indeed retrieve the data from Excel based on conditions by connecting to Excel as a Database and pulling the data through a Query with the necessary condition on the Database Query.

     

    For assistance through our Support Engineers, please reach us via Support case

     

    https://apeople.automationanywhere.com/s/article/How-to-create-a-support-case-in-service-cloud/p>

     

    You can also check our Live Chat support option, for quick assistance from our engineers

     

    https://apeople.automationanywhere.com/s/article/Live-Chat-Support-FAQs/p>

     

    You can also search for available documentation in

     

    https://docs.automationanywhere.com//p>

     

    For more details, you are welcome to leverage our open source portal where multiple use case is available

     

    https://botstore.automationanywhere.com//p>