Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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.
Could you please share the error encountered
my system got hanged up and didnt load as there are tons of rows in it like from 2013 to 2019 date
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
its has loaded one table but when i try to load another table my system get crashed as it had lakhs of rows.
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.