This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
This would be much better than having to output the data to an Excel tab or csv file in order to link to Excel pivot tables. The pivot tables could link directly to the yxdb files.
Having Excel read a new data format is a Microsoft issue that Alteryx can't control.
Does this article provide any help in what you trying to do (or at least get you started in the right direction)? https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Excel-to-Alteryx-API/ta-p/85766
Actually what I"m needing is an OLE DB Provider for Alteryx that Excel can use. Dell built a DLL for Statistica for the ability to make a connection in Excel to link in data for pivot tables. Be great to have one for Alteryx.Here is the connection properties for Excel linking to a Statistica file:
Provider=STATISTICA.StaOLEDB.1;Data Source=\\PATH TO YOUR ALTERYX yxdb file;Integrated Security="";User ID="";Extended Properties="";Strip Formatting=TRUE;Auto calculate spreadsheet=FALSE;Connection String="";Station Name="";Excel Style Julian Dates=TRUE
I like the idea of non-alteryx license holders having read access using excel to data in an alteryx database. Is there a way to do this?
The status of this idea has been changed to 'Inactive'. This status indicates that:
1. The idea has not had activity in the form of likes or comments in over a year.
2. The idea has not reached ten likes.
3. The idea is still in the 'New Idea' status.
However, this doesn't mean your idea won't be implemented! The Community can still like and comment on this idea. With enough renewed interest, this idea can be brought back into the 'New Idea' status.
Thank you for contributing to the Alteryx Community and the Alteryx Product Idea Boards!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.