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…?
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:
Always search first. It is the best way to quickly find your answer. Check out the icon for that.
Clicking the options button will let you set more specific topic search filters, i.e. only the ones with a solution.
Topic that contains most common solutions with example project files can be found here.
Read our official documentation where you can find a lot of information and instructions about each of our products:
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!
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…
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…
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…
dokumentor
Bot_Learner1
lrtetala