Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
riishabhz
Contributor

load sql file

hi everyone

i have connected my qlikview to sql server , as i am in retail company so every table in sql updates daily and have data from 2013 till now.

i want to load just 5 tables from sql server to qlikview.

i tried loading multiple table but after loading the data it doesnt show up.

please tell me how do i load my sql data that is from 2013 year .

1 Solution

Accepted Solutions
ramasaisaksoft
Valued Contributor III

Re: load sql file

try like below

Tab 1:

LOAD Name,
rowno() as SNO,
[IP Address],
[Access Denied]
FROM
[C:\Users\gvramasai\Desktop\2018 Data.xlsx]
(ooxml, embedded labels, table is Sheet1)
where rowno() <10;

No concatenate

Tab 2 :

LOAD Name,
rowno() as SNO,
[IP Address],
[Access Denied]
FROM
[C:\Users\gvramasai\Desktop\2018 Data.xlsx]
(ooxml, embedded labels, table is Sheet1)
where rowno() <10;

 

etc...

try like this ,so that you will get 10 rows from each table.

                                    Else

 

still if you are getting any issue then check like

Load table  1 for 10 records

if everything is good comment the code till now 

Load Table 2 for 10 records

if everything is good comment the code till now 

upto 5 tables you can check and confirm by yourself which table you are facing issue.

5 Replies
anushree1
Valued Contributor

Re: load sql file

Could you please share the error encountered

riishabhz
Contributor

Re: load sql file

my system got hanged up and didnt load as there are tons of rows in it  like from 2013 to 2019 date

anushree1
Valued Contributor

Re: load sql file

Go to debugger and run the code for around 100 rows and check so that we know is it the load which is causing the issue or any error in the script

riishabhz
Contributor

Re: load sql file

its has loaded one table but when i try to load another table my system get crashed as it had lakhs of rows.

ramasaisaksoft
Valued Contributor III

Re: load sql file

try like below

Tab 1:

LOAD Name,
rowno() as SNO,
[IP Address],
[Access Denied]
FROM
[C:\Users\gvramasai\Desktop\2018 Data.xlsx]
(ooxml, embedded labels, table is Sheet1)
where rowno() <10;

No concatenate

Tab 2 :

LOAD Name,
rowno() as SNO,
[IP Address],
[Access Denied]
FROM
[C:\Users\gvramasai\Desktop\2018 Data.xlsx]
(ooxml, embedded labels, table is Sheet1)
where rowno() <10;

 

etc...

try like this ,so that you will get 10 rows from each table.

                                    Else

 

still if you are getting any issue then check like

Load table  1 for 10 records

if everything is good comment the code till now 

Load Table 2 for 10 records

if everything is good comment the code till now 

upto 5 tables you can check and confirm by yourself which table you are facing issue.