topic What is the Qlikview syntax for SQL Server's DB_NAME() in QlikView

What is the Qlikview syntax for SQL Server's DB_NAME()

Fri, 10 Jan 2014 19:26:11 GMT

I need to pull data from different databases. There are no unique keys across the different databases. I would like to create a unique key by concatenating the database name, which can be found using DB_NAME() in SQL Server, with the unique key found within the database. Is there a way to pull data into Qlikview, directly from SQL Server and accomplish this?

Thanks in advance,

Anthony

Re: What is the Qlikview syntax for SQL Server's DB_NAME()

Gysbert_Wassenaar — Fri, 10 Jan 2014 19:38:20 GMT

You can simply use the sql select statement you would use when working with SQL Server directly:

TableInQlikview:

select *, UniqueKey + DB_NAME() as Key

from dbo.TableInSQLServer;

Re: What is the Qlikview syntax for SQL Server's DB_NAME()

Fri, 10 Jan 2014 19:41:48 GMT

Hey Anthony,

If you want to create a unique key for a table, why don't you try using RowNo(). This will give a unique number for each row(it will also be sequential based on load order). Also when you pull the table you will be knowing which database you are pulling from. Just Create a field like 'Microsoft DB' as [DB Name] for each of the tables with their respective DB names. Store those tables in qvds and later use those qvds to perform your modelling

Hope this was of some help.

Thanks