I am a new uiPath programmer, been using Studio for about 5 months.

Been asked to use Studio X for a small project to see how good a fit it would be for business users.

My task is to take an Excel spreadsheet and create a new one spreadsheet where Column X and Column Y are totaled for values that are the same in column A. So if we have 4 rows where column A is “684” then a new spreadsheet is produced with on row where column A is “684” all other columns are the same except column X and Y are totaled.

First off I do not see data tables being available in Studio X. Am I missing something?

Have added the Excel Add. My approach if I do not have data tables is to read rows in the first table and keep a list of values until we reach a new row that has a different number in column “A” and then write a line to the new excel and blank the values and keep reading.

Any suggestions would be greatly appreciated.

Any feedback about the success (or lack thereof) of allowing business users to use Studio X? with