load sql file

[riishabhz]

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 .

[anushree1]

Could you please share the error encountered

[riishabhz]

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

[anushree1]

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]

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

[ramasaisaksoft · Accepted solution]

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.