Discussion board where members can get started with Qlik Sense.
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
Go to Solution.
It seems that Generic load need 3 fields... you have way more
The Generic Load
i am writing like this but it is not working :
FROM 'DEV1-PC-MSSQLSERVER2014 (desktop-dpummb2_yaman.dbo.ComplexType');
Once you have created a connection, you can pull data using one of the two buttons here
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 .
What do you mean..?? It should look like this
Generic LOAD ....
SQL SELECT ...
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.
Can you paste the exact script you used?
May be without Preceding LOAD
SQL Select * From ComplexTable;
However, are You sure You need Generic Prefix ?
You will get a complex model with a lot of tables.