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

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

loading the context variable value after completion of a job

Hi All,

 

I have create one job with some context variable(values will changes over execution).

 

after end of the job i want load the context variable into a file using tPostJob.

 

How to do it?

 

Thanks

shree

Labels (2)
1 Solution

Accepted Solutions
SachinD
Creator
Creator

Thanks @bshree88,for your confirmation.

 

Can you please accept my solution, This allows others to see what has worked.

 

Thanks,

Sachin

Lets share and learn!

 

 

View solution in original post

9 Replies
SachinD
Creator
Creator

 

 

Hi @bshree88

 

You can use tContextDump, as shown below,

Please accept solution if you think it helps you, Thanks.

 

Thanks,

Sachin

 

 

0683p000009LqyE.jpg

Anonymous
Not applicable
Author

Hi bshree88,

You can use tFixedflowInput as shown below,

Please accept as solution if  it helps you

 

Thanks,

Abhi529

0683p000009Lqrd.jpg

tfixedflowinput properties as,

 

0683p000009Lr5A.jpg

 

 

 

 

 

Anonymous
Not applicable
Author

Hi Sachin,

 

Can you show me the tFileOutputDelimited properties.

and one more there few context variables, the values of those variables changing at run time. i need to capture those values and store into file.

 

some other jobs i need to use this  context variable values  using tcontextload components.

 

Thanks

shree

 

 

Anonymous
Not applicable
Author

Hi Abhi529,

 

Can you show me the tFileOutputDelimited properties.

and one more there few context variables, the values of those variables changing at run time. i need to capture those values and store into file.

 

some other jobs i need to use this  context variable values  using tcontextload components.

 

Thanks

Shree

SachinD
Creator
Creator

Hi Shree,

 

tFileInputDelimited has basic properties set as

File Name, Filed Seperator

 

as you are capturing context variable in post jobs, you will get updated values of variables, as you mentioned variables are changing run time.

 

 

 

0683p000009Lqzc.jpg

 

 

In another JOB.

u can use same created file and load the context variable in some another job using tContextLoad.

But Schema should be Key Value as shown below.

 

 

 

0683p000009LrF9.jpg

 

Please accept the solution if it helps you.

 

Thanks,

Sachin D.

Anonymous
Not applicable
Author

Thanks Sachin.

 

Sound good it's working fine.

 

Regards

Shridhar

SachinD
Creator
Creator

Thanks @bshree88,for your confirmation.

 

Can you please accept my solution, This allows others to see what has worked.

 

Thanks,

Sachin

Lets share and learn!

 

 

Anonymous
Not applicable
Author

Hi bshree88,

For your information,

here is the tFileOutputDelimited properties..

0683p000009LrBN.jpg

and schema is,

 

0683p000009LqpI.jpg

Anonymous
Not applicable
Author

Hi Sachin,

 

After completion of job is file is created. But it is not capturing latest values before compilation of job.

 

Please find the attached file for your references.

 

Thanks

Shree


context_load.txt