One top right corner, there are three dots, when I click on it, it gives me two options of link which I stated above. Can you please guide me which connector works for this scenario. I have Nov 2017 Web connector too.
Yes, I did but I will load a new file every month, so I will get a new Unique Id for every file, so every month I will have to add it to my script. Is it possible to automate it on the script only one time?
If you are only interested in that one file you should be able to get the Id without doing the loop, by adding a WHERE statement to the first table. You may be able to do a filter on the initial load, but if not you can do it on a preceding load.
Id_Table: LOAD * WHERE Match(Name, '*Filename.xlsx') ; LOAD Text(UniqueId) as UniqeId, etc...
When you say that it's not working, is the variable v3rdWorkday not containing the ID, or is it another issue?
I think what the issue might be is that you are missing single quotes around $(vFile), so the match line should start:
In order to be able to run a LOAD directly from a URL you would need to have your server switched to legacy mode in QMC. If this is not set then you will get an error message saying that you can only load from libraries. I'm guessing that is set correctly to allow you to load direct from URLs?
You can always test QWC statements by copying and pasting the URL into a browser. If you can't copy it from the progress dialog then you should be able to find it in the log file for the app reload, or store it to a text file like this:
'https://qwc.server:5555/etc.etc.' as Connection
STORE tmpConn INTO [lib://mylibrary/QWCURL.txt] (txt);
DROP TABLE tmpConn;
When you paste the URL into your browser you will either get some data or an error message. That error message could be very useful. Depending on your QWC settings you may need to RDP to the QWC server to get a full message, as by default it gives out generic messages to calls from remote machines.
I don't think that the data that comes back from that stream will be a QVX, I think it is more likely to be a binary stream of that Excel file. In which case, the format specifier would not be (qvx) on the end, rather the same (ooxml, etc.) that you have when loading the spreadsheet from a file connection. If when you paste the URL into your browser it downloads the Excel file this is what you will need to use.
Hopefully one of those things will point you in the right direction a little.
That being the case you have two choices, one is to put Sense into Legacy mode. This will allow you to run script that works on QlikView against Sense. This is not the recommended route.
The other way is that you create a generic Get connection to somewhere random (e.g. https://jsonplaceholder.typicode.com/posts) and then use the WITH CONNECTION statement to replace the URL with the one you have constructed from variables, like this: