How to join 2 data tables and run a query

Hi Im a rookie UiPath Dev and need help from the experts

Steps im trying to do as below:

  1. Join 2 data tables which i grab from excel
  2. Run a SQL query on the joint tables

Im extracting 2 sets of data from 2 separate excel spreadsheets and i need to find the matching rows and do a group by.

Thank you all


Hi @bpgacad
For joining the two datatables there is one activity in uipath “Join Datatable”. You can use it.

hi @jitendra_123

yep i tried using that already but it’s not letting me do a group by.

I need group by functionality and was wondering if there was anything i could use e.g. activity or xaml files within the community that i can just pick up and use