Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
1adam_haj
Contributor III
Contributor III

Dynamic load of name of database

Hello i have database connection to MS SQL database that has a Timestamp format name like this : 05-03-2018-12-23-35_DB1

And every time when something changes in the database, the name is changed due to change time - the new timestamp name..


So what I need is dynamic load of name of database, to some variable probably and then load it from the variable as the table source ?

1 Reply
isorinrusu
Partner
Partner

Hi Adam,

What about doing a left(TIMESTAMP,19) which would return 05-03-2018-12-23-35? This way you won't have to worry about the DB name.


Or is it the field name that is changing?


Regards,

Sorin.