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.

  • 23 February 2022
  • 1 reply
  • 1 view

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

Userlevel 4
Badge +8

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>

 

Reply