I have been using Tableau for a few months now and now have several issues that I've looked everywhere in forums for solution on both subjects.
This is just a demo to show, not the actual project.
1. I have an xls file which has currency forex rates that are streamed from a website into the file, then I add the file to Tableau as a connection. Now, if I would like to multiply one of the columns by an integer, I get an error saying that "cannot multiply float value by string". I understand how in one forum post (https://community.tableau.com/thread/120206) that you need to convert the float value before the operation, however this piece of code did not work. It seems like the post was based on some older Tableau software that had it working for whatever reason.
Secondary question to this: if an xls file with web data is set to refresh every hour, theoretically it should work with Tableau since the file is being updated before being passed to Tableau - right?
2. Is there anyone out there who has experience using Web Data Connectors to pull foreign exchange values into their Tableau? There has been a number of posts in the forums, and other blogs with links to specific WDC for currency exchange, namely:
However, none of these worked. One was created with old Tableau Software and doesn't fill, the other two simply go into an infinite loop when the program is queried to load data. Is there anyone that has knowledge of a working WDC, to where building one is not needed? I saw in one solution, was to create a client with the API into the web page, then pass it to Tableau. However my teacher would not accept that as a solution, since it makes the business solution too complex.
3. Google Finance Spreadsheet connection to Tableau
The whole reason I am here in the first place, is because I had successfully used Google Sheets to load currency data and create new values based on those. However, when I share the files with my teacher he is asked for my login when he opens the file to grade my work. He then asked me to find a different solution, which is why I was looking into finance data feed into xls, or web data converters.
If anyone knows how to load the Google Finance numbers into Tableau without having to prompt every user to login with credentials - that would help tremendously.
I attached the xls, Test Worksheet that is pulling its data, and the extract file. Anyways, I am just looking for a simple way to add dynamic currency conversions into Tableau without too much hassle. I spent many hours researching this issue. With Power BI I could simply access a rates table like on xe.com and select the table there very quickly. It seems much more complicated with Tableau.