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

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 6
Badge +9

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>


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


You can also search for available documentation in>


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