Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to load particular table in script

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.

6 Replies
Not applicable
Author

Hi,

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

which Is the table you are going to reload

like

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

Not applicable
Author

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

jagan
Luminary Alumni
Luminary Alumni

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.

Not applicable
Author

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

Not applicable
Author

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.

Not applicable
Author

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 ).

Untitled.png