topic Re: load sql file in QlikView

load sql file

riishabhz — Sat, 16 Nov 2024 20:33:14 GMT

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 .

Re: load sql file

anushree1 — Mon, 01 Jul 2019 06:22:23 GMT

Could you please share the error encountered

Re: load sql file

riishabhz — Mon, 01 Jul 2019 06:30:50 GMT

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

Re: load sql file

anushree1 — Mon, 01 Jul 2019 06:45:32 GMT

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

Re: load sql file

riishabhz — Mon, 01 Jul 2019 07:25:34 GMT

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

Re: load sql file

ramasaisaksoft — Mon, 01 Jul 2019 10:19:13 GMT

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.