Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
terceroulloa
Contributor
Contributor

Use of Implicit tContextLoad

To load a context I used tFileInputDelimited and tContextLoad.
It also worked using "Implicit tContextLoad from file".
But can't make it work using a database as a source. Tried both ways, tContextLoad and Implicit tContextLoad.
Using Implicit tContextLoad, I have two problems:
- How do I fill Query condition field? Is it obligatory?
- In the components that use this context, is it ok (Port field as example): context.port?
My database is like:
"key" "value"
"database" "dbname"
"host" "hostname"
"password" "password+"
"port" "3306"
"username" "root"
Thanks, Rober
Labels (2)
2 Replies
Anonymous
Not applicable

Hi
You can load the value of context variables from any data source. From database, the query should be:
"select key, value from your_table_name"
The job looks like:
tMysqlInput--main--tContextLoad
   |
onsubjobok
  |
other business processing
Regards
Shong
terceroulloa
Contributor
Contributor
Author

Ok, thanks.
But in the Contexts Tab I have a filename (File type) field, which worked when using a file. Leaving it like this works, but should I remove that value? Or change it?
Rober