Using StuidoX Create Pivot Table in Studio

I understand you can use the StudioX Create pivot table in regular Studio…
It looks to have better features around the result you would get out i.e. Field/Is a multiple options etc…

I’ve been really struggling to get it to work in regular Studio, I’ve looked through all the StudioX tutorials trying to figure it out and then realised someone “OUT THERE” in Forumland will have already figured it out…

So, is anyone able to share a simple HOW2 guide on using the StudioX Create Pivot Table from within Studio…?

Thanks in Advance
Dawn

Hello @DawnW!

It seems that you have trouble getting an answer to your question in the first 24 hours.
Let us give you a few hints and helpful links.

First, make sure you browsed through our Forum FAQ Beginner’s Guide. It will teach you what should be included in your topic.

You can check out some of our resources directly, see below:

  1. Always search first. It is the best way to quickly find your answer. Check out the image icon for that.
    Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.

  2. Topic that contains most common solutions with example project files can be found here.

  3. Read our official documentation where you can find a lot of information and instructions about each of our products:

  4. Watch the videos on our official YouTube channel for more visual tutorials.

  5. Meet us and our users on our Community Slack and ask your question there.

Hopefully this will let you easily find the solution/information you need. Once you have it, we would be happy if you could share your findings here and mark it as a solution. This will help other users find it in the future.

Thank you for helping us build our UiPath Community!

Cheers from your friendly
Forum_Staff

I really only need to know how to reference the excel columns/table in the spreadsheet using the studio x pivot table creator within Studio… I have an excel filename that changes based on the date it is run, so cannot link a static filename to the activity like it shows in the studio x tutorial…

Any help greatly appreciated…

Hi @DawnW - Have you tried Directory.GetFiles(folderpath, yourfilepattern)(0)…

Please share the same file name and how it changes based on the date.

I have the changeable filename saved in a variable so as below Location:
“W:\Reports\Robot” + Filename

I’m just struggling to use it/get the right syntax in the StudioX create pivot table, but within Studio…

In StudioX the Source : [ExcelFilename] Sheet1!A:E
(whereas the “ExcelFilename” is picked up from the Reference box in the StudioX Use Excel File activity)

In Studio most references have to be surrounded by Quotes or braces… I have tried a lot of variations but am still getting Compiler errors in the Source and Destination box within the create Pivot Table StudioX activity…

NB: Assuming that to use the StudioX create pivot table activity within Studio requires the StudioX Use Excel File activity around it…

I wanted to use the StudioX activity as it seems to have a better functionality regarding setting up the Pivot Field setup as apposed the automatic generic pivot created in the Studio one…

@DawnW - This is the Pivot table which I built in StudioX. I have opened that file in Studio and this is what I got…You can see All the excel.sheet and excel.table as automatically added since I opened it in Studio

You can ignore Format as table activity if it’s not required…

You can try something like this…

I am getting an error of “Saved” is not declared…

What does “Saved” and “Surcharge” relate to in your workflow…?
Table created name in your Format as table…?

@DawnW - That was just to sample workflow to show you. Below are the options i am thinking of…

  1. You can create pivot table workflow in StudioX and open that workflow in Studio. It will work flawlessly I have tried in the past.

  2. Create a Pivot in Studio by carefully mimicking how studioX pivot table works by opening the workflow created in Option 1.

Let me try some sample in Studio and I will share it with you…

I didn’t realise I could swap between Studio and StudioX on the same PC…?

@DawnW - yes you can…

  1. Create a workflow in StudioX after changing the profile to StudioX
  2. Change the profile to Studio and open the workflow create in Step 1

Please try and let me know…

Note: Screenshot shared above by me was similar one as explained above…

Thank You, Thank you…

Yay… It worked to create it and get it working in StudioX and then open it in Studio…
That is a great tip, that I will use and also pass onto others in the future…

The StudioX activity is so much more powerful from choice of columns/rows etc…

Thanks again…
Dawn

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.