How to pass multiple values to a context

[sushantk19]

Hi,

Is there a way we can define & pass multiple values to a context? e.g

context.brand_id=(1,2). how to define this in contexts tab? context.brand_id= "1|2"?

[Anonymous]

@sushantk19 : not together but yes multiple values you can define in a parameter txt file like: context.brand_id;1 context.brand_id;2 either load using tcontextload or implicit context load (or store in DB). Let me know if that makes sense !

[Anonymous]

@sushantk19 : not together but yes multiple values you can define in a parameter txt file like: context.brand_id;1 context.brand_id;2 either load using tcontextload or implicit context load (or store in DB). Let me know if that makes sense !

[manodwhb]

@sushantk19 , yes agreed with @snayak , you need to maintain a table or file from there you need to iterate and pass one parameter by one and you need to complete your downstream flow.

[manodwhb]

@sushantk19 , yes agreed with @snayak , you need to maintain a table or file from there you need to iterate and pass one parameter by one and you need to complete your downstream flow.

[sushantk19]

@snayak : Thanks. Do i need to change my existing job design. Frankly, speaking i would not like to do this as we are in QA phase now I have attached my job design for your reference. ALso, can u share any link or job design how this can be implemented? what do you mean by implicit context load??

[sushantk19]

@snayak : Thanks. Do i need to change my existing job design. Frankly, speaking i would not like to do this as we are in QA phase now I have attached my job design for your reference. ALso, can u share any link or job design how this can be implemented? what do you mean by implicit context load??

[sushantk19]

job design is attached.

context_multiple_values.png

[sushantk19]

job design is attached.

[Anonymous]

simple solution: prepare your context parameter file x;1 x;2 then pass this file as normal tfileinputdelimited > tflowtoiterate> Iterate link to your entire job (or use that job as tRunJob) when you run your mother job , the value of x will be passed one by one for every iteration. Possible to do the same thing in different ways also. Feel free to give kudos to solutions, if it helps !