Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

Generic

SELECT

       ParentID,Name,ID

FROM YourTableName;

View solution in original post

3 Replies
swuehl
MVP
MVP

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

Generic

SELECT

       ParentID,Name,ID

FROM YourTableName;

shraddha_g
Partner - Master III
Partner - Master III

TableName will be there.

But makesure you use correct databasename before table Name.

Anonymous
Not applicable
Author

Thanks it is solved.