Data manager and changing LIB with environments

[Michiel_QV_Fan]

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?

[molinaantonio]

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]

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

[molinaantonio]

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