Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

yamananalytic
Contributor 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

Tags (1)
1 Solution

Accepted Solutions

Re: Connection path to SQL Server

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

The Generic Load

12 Replies
yamananalytic
Contributor II

Re: Connection path to SQL Server

i am writing like this but it is not working :

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

Re: Connection path to SQL Server

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

Capture.PNG

yamananalytic
Contributor II

Re: Connection path to SQL Server

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  .

Re: Connection path to SQL Server

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

Generic LOAD ....

...

...;

SQL SELECT ...

...

...

FROM ....;

yamananalytic
Contributor II

Re: Connection path to SQL Server

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.

Re: Connection path to SQL Server

‌Can you paste the exact script you used?

yamananalytic
Contributor II

Re: Connection path to SQL Server

p2.png

Re: Connection path to SQL Server

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

The Generic Load

antoniotiman
Honored Contributor III

Re: Connection path to SQL Server

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

Community Browser