Discussion board where members can get started with Qlik Sense.
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 :
ParentID,Name,ID From ????
what should i write after ''From'' keyword to reach Complex Type table.
Please can you help me.
Go to Solution.
You need to use a SELECT statement when reading from your SQL database:
TableName will be there.
But makesure you use correct databasename before table Name.
Thanks it is solved.