topic Re: how to load particular table in script in QlikView

how to load particular table in script

Wed, 11 Mar 2015 07:00:43 GMT

hi,

i my application am using, 5 table from sql server.

i update any data in one table, how can i reload the particular table in qlikview

script is simple - select * from table.

Re: how to load particular table in script

Wed, 11 Mar 2015 07:11:47 GMT

Hi,

use partial reload in file menu before that add one function in script

which Is the table you are going to reload

Replae

Table:

one this is done save the Document and come to the front end in file menu u will find one partial reload option click that its automatically that table will get reload

Thanks

Manju

Re: how to load particular table in script

Wed, 11 Mar 2015 07:33:22 GMT

Hi Arjun,

In script write 'Add' Prefix above Load or Select statements and save it.

in UI select file menu and select Partial reload or Press ctrl+alt+r.

thanks,

chennaiah

Re: how to load particular table in script

jagan — Wed, 11 Mar 2015 08:02:55 GMT

Hi,

Try Partial Reload with Replace, the table which you want to reload just prefix Replace before Load statement

Examples:

Tab1:

Replace Select *From Table1;

For loading this you need to follow below steps

1. Come out of the Edit Script window

2. File Menu -> Partial Reload option

Hope this helps you.

Regards,

Jagan.

Re: how to load particular table in script

Wed, 11 Mar 2015 08:11:01 GMT

Hi,

That can be done by using partial reload.

For Eg:

Table:

ADD load * from DataBase_Tabel;

save the the script and come out from script.

And please follow these steps for reload.

1).go to File Tab in UI level

2)then click on Partial Reload

Hope this can helps u.

Thanks,

Raja

Re: how to load particular table in script

Wed, 11 Mar 2015 09:01:45 GMT

Hi Arjun,

 Partial load we can load only few tables instead of all the tables available in the document.

 Use: Partial Load is very useful in the scenario, where the data changes in less number of tables.

It takes less time to load the few tables.

Few tables will be loaded, which are preceded by ADD/REPLACE statements.

Re: how to load particular table in script

Wed, 11 Mar 2015 10:17:54 GMT

Hi Arjun,

If you can extract the data from SQL server, first go to scripting in qlik view and then select OLEDB and connect the connect button. And then display one pop up window after that select the OLEDB provider. Follow these steps, you will connect and then select tables from SQL server then reload it(reload short cut is ctrl+alt+r ).