Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
yamananalytic
Not applicable

Generic Load Problem!!!

Hi guys ,

I have a data stored on Sql server 2014 contains one table called Complex Type.

what i want to do is generate a generic prefix fro Complex Type table.

Firstly i made a connection to data base by writing this statement :

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


after that i want to generate generic prefix using this statement :


Generic LOAD

       ParentID,Name,ID From ????

swuehl

stalwar1diego.a.barbozahic

what  should i write after ''From'' keyword to reach Complex Type table.

Please can you help me.

Tags (1)
1 Solution

Accepted Solutions
swuehl
Not applicable

Re: Generic Load Problem!!!

You need to use a SELECT statement when reading from your SQL database:

Generic

SELECT

       ParentID,Name,ID

FROM YourTableName;

3 Replies
swuehl
Not applicable

Re: Generic Load Problem!!!

You need to use a SELECT statement when reading from your SQL database:

Generic

SELECT

       ParentID,Name,ID

FROM YourTableName;

shraddha_g
Not applicable

Re: Generic Load Problem!!!

TableName will be there.

But makesure you use correct databasename before table Name.

yamananalytic
Not applicable

Re: Generic Load Problem!!!

Thanks it is solved.