Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ashishpalkar
Contributor II

Add additional data with binary data load

Hi There

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.

7 Replies
shraddha_g
Honored Contributor III

Re: Add additional data with binary data load

Can you share your script n error you are getting?

ashishpalkar
Contributor II

Re: Add additional data with binary data load

Hi

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,

xufei123
Valued Contributor

Re: Add additional data with binary data load

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?

Fei

arvind654
Honored Contributor II

Re: Add additional data with binary data load

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.

shraddha_g
Honored Contributor III

Re: Add additional data with binary data load

You can also add by Data Manager once you add binary statement on 1st line.

s0001161624
New Contributor

Re: Add additional data with binary data load

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

xufei123
Valued Contributor

Re: Add additional data with binary data load

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:

Binary ;

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:

Binary [lib://Desktop/temp.qvw];

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.

Fei.