Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Michiel_QV_Fan
Specialist
Specialist

Data manager and changing LIB with environments

we have 3 environments, DEV, TEST and PROD.

Each has its own LIB connection, like: lib://qlikview@dwh_load@test

We have to use a variable based on the file name to determine which environment to load from (dev, test, prod).

But,

when using Data Manager this variable cannot be set without unlocking the script. And I want to use data manager as script editor.

Is there a solution for this to get the variable lib in the table extraction in data manager?

Labels (1)
3 Replies
molinaantonio
Contributor II
Contributor II

Hello @Michiel_QV_Fan 

Crazy Idea over here 😁 (kind of old approach)

Try to have a file (like csv):

e.g. (pasted an inline version in attachment)

Server, Environment, Lib

node1, dev, lib-de

node2, dev, lib-dev

node1, test, lib-test

node2, test, lib-test

node1, prod, lib-prod

node2, prod, lib-prod

Having a file like this you can drag & drop it to the data manager to use it alog with in the script the function ComputerName() (has to match with the column Server of the csv file to work properly)

 

Hope it helps you 😀

Rgds,

Toni

Michiel_QV_Fan
Specialist
Specialist
Author

Thanks. But still, the LIB cannot be changed in Data manager. That is fixed and locked.

molinaantonio
Contributor II
Contributor II

Question, are you looking to modify directly there because the app has old data and you want somehow modify the values?

If so, maybe you can store all the tables inside the app into csv. Delete the one that is bothering you with old data and follow the approach mentioned in my prior entry :).

Rgds,

Toni