Hi, I'm trying to use tcontextload to load a couple of context variables with the use of a table, but when I do so it's not recognizing the values I put in through another job.
The table I created is an ETL control table with key and value columns (see screenshot). I then run the job which seems to assign value to e.g. the date_batch context variable and try to use the date_batch variable in another job. When I do so that value is empty (see screenshot).
Thanks for your reply. As you can see from my jobs in the screenshot, I did have a context table with the columns key and value. Also what I'm trying to achieve is to create a global context variable so that I don't have to use parent and child related jobs. Is that possible?
As you can see from the first screenshot, I had mappend the table with the tcontext load, but the goal is to create a global context variable and populate it dynamically.
@Roland Siem ,can you share your full job design,if you are not using parent and child job, and have single job first load context and then take on subjob Ok from conetxt load flow and connect the next what you want to do and called required context variable ,it will work.
One question I have first is, do you always need to have either a parent/child combo or an overarching job that encompasses a job that loads the context followed by another that uses it? Because I want the context load job to stand on its own and just load the context variables that I then want to use for a whole variety of jobs.
