Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
yamananalytic
Creator II
Creator II

Connection path to SQL Server

Hi guys,

i want to use generic load statement but the data is on the server and i made connection to the data but how can i write the connection path

p2.pngswuehl

stalwar1

1 Solution

Accepted Solutions
sunny_talwar

‌It seems that Generic load need 3 fields... you have way more

The Generic Load

View solution in original post

12 Replies
yamananalytic
Creator II
Creator II
Author

i am writing like this but it is not working :

FROM 'DEV1-PC-MSSQLSERVER2014 (desktop-dpummb2_yaman.dbo.ComplexType');

sunny_talwar

Once you have created a connection, you can pull data using one of the two buttons here

Capture.PNG

yamananalytic
Creator II
Creator II
Author

yes i did so and this is generated :

LIB CONNECT TO 'DEV1-PC-MSSQLSERVER2014 (desktop-dpummb2_yaman)';

but when i write generic load statement after From keyword which path i should write  .

sunny_talwar

What do you mean..?? It should look like this

Generic LOAD ....

...

...;

SQL SELECT ...

...

...

FROM ....;

yamananalytic
Creator II
Creator II
Author

i did as you said

now no error happens

but also i did not get the generic load

i got just the original table.

so can i solve it.

sunny_talwar

‌Can you paste the exact script you used?

yamananalytic
Creator II
Creator II
Author

p2.png

sunny_talwar

‌It seems that Generic load need 3 fields... you have way more

The Generic Load

View solution in original post

antoniotiman
Master III
Master III

May be without Preceding LOAD

Generic

SQL Select * From ComplexTable;

However, are You sure You need Generic Prefix ?

You will get a complex model with a lot of tables.

Regards,

Antonio