I am loading data using Binary load in Qlik Sense App.
Now I am trying to add excel data from my local machine into my app. I am not able to load any data after Binary data load,
Is there any way we can resolve this?
Thanks in advance.
Please find below steps,
1. Create app name 'Data App' with some amount of data into it,
2. Now create another app called 'Binary App'
3. In Data Load Editor type below script function
binary [path] filename
4. Now load the 'Binary App'.
5. Once app if loaded , try to add data excel or any other date from data Manager.
Hope this helps,
You can binary reload another app using the absolute full path like c:\dir1\dir2\.... but when you load other data for example from spread sheet, you need to set up a folder connection and load the spread sheet using it.
Otherwise what error message did you get when the reload failed?
Binary Load script should be the first script in your load editor.
On the Line 1.
You can load any other file after binary load. As Fei mentioned above, you'd need a new Data connection to load data from XL file.
I did exactly this:
Binary statement at 1st line
attached XL file with drag&drop
But this doesn't work.
And I would really need an own folder connection just for adding my local files???
The other way round works:
Attach XL file with drag&drop, load data, add binary statement, load data again
Which version of Sense are you using?
I just did a quick test. I can use absolute path to do binary reload in Sense September 2017 like this:
However I cannot do that in Sense November 2017 patch 2. It showed the error saying that I have to use data connection. This works:
So I use data connection to do binary reload at the first line in the script and then I drag some Excel file in data manager and it is working for me.