Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Tags (2)
6 Replies
Not applicable

Re: how to load particular table in script

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

Re: how to load particular table in script

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

MVP
MVP

Re: how to load particular table in script

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

Re: how to load particular table in script

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

Re: how to load particular table in script

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

Re: how to load particular table in script

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

Community Browser