Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted

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.

View solution in original post

5 Replies
Highlighted
Specialist II
Specialist II

Could you please share the error encountered

Highlighted
Creator
Creator

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

Highlighted
Specialist II
Specialist II

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

Highlighted
Creator
Creator

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

Highlighted

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.

View solution in original post