topic Re: How to pass multiple values to a context in Talend Studio

How to pass multiple values to a context

sushantk19 — Sat, 16 Nov 2024 01:58:57 GMT

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"?

Re: How to pass multiple values to a context

Anonymous — Fri, 03 Jul 2020 17:42:59 GMT

@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 !

Re: How to pass multiple values to a context

Anonymous — Fri, 03 Jul 2020 17:42:59 GMT

Re: How to pass multiple values to a context

manodwhb — Sat, 04 Jul 2020 06:52:01 GMT

@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.

Re: How to pass multiple values to a context

manodwhb — Sat, 04 Jul 2020 06:52:01 GMT

@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.

Re: How to pass multiple values to a context

sushantk19 — Mon, 06 Jul 2020 07:17:50 GMT

@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??

Re: How to pass multiple values to a context

sushantk19 — Mon, 06 Jul 2020 07:17:50 GMT

Re: How to pass multiple values to a context

sushantk19 — Mon, 06 Jul 2020 07:25:22 GMT

job design is attached.

context_multiple_values.png

Re: How to pass multiple values to a context

sushantk19 — Mon, 06 Jul 2020 07:25:22 GMT

job design is attached.

Re: How to pass multiple values to a context

Anonymous — Mon, 06 Jul 2020 18:50:21 GMT

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 !

Re: How to pass multiple values to a context

Anonymous — Mon, 06 Jul 2020 18:50:21 GMT

Re: How to pass multiple values to a context

sushantk19 — Tue, 07 Jul 2020 07:46:23 GMT

@snayak : i know its simple . since I am new to talend, i am not getting it correct. some small mistake is happening somewhere. can you please point out that to me?Please find the context file attached along with other screenshots such as job design, error message and tfileinputdelimited datatype defination.

can you please point out the error to me?

Re: How to pass multiple values to a context

sushantk19 — Tue, 07 Jul 2020 07:46:23 GMT

can you please point out the error to me?

contexts_productcat.txt
tcontext_error1.png
tcontext_error2.png
tcontext_error3.png

Re: How to pass multiple values to a context

manodwhb — Tue, 07 Jul 2020 09:19:29 GMT

@sushantk19 , what are you doing in tMap2,can you share screenshot of tMap2? the error you are getting is compilation error not run time error. you have not configured correctly for one or more columns.When comparing strings you should use equals instead of == . One more thing that let have below way. not needed context. .

prodcat_mia1;6

prodcat_mia1;7

Re: How to pass multiple values to a context

manodwhb — Tue, 07 Jul 2020 09:19:29 GMT

prodcat_mia1;6

prodcat_mia1;7

Re: How to pass multiple values to a context

sushantk19 — Tue, 07 Jul 2020 12:32:57 GMT

@manodwhb : please find attached the screenshot for tmap2. Based on product categories and date interval, we are calculating the VAT rates. For product category 7 and 8, the calculation is same. Hence i want to pass both these values in a single context.

When i run the job with above suggestions , i get the below error:

Couldn't parse value for column 'value' in 'row13', value is 'prodcat_mia1'. Details: java.lang.NumberFormatException: For input string: "prodcat_mia1"
Couldn't parse value for column 'value' in 'row13', value is 'prodcat_mia1'. Details: java.lang.NumberFormatException: For input string: "prodcat_mia1".

i have defined a context with name as prodcat_mia1 in "contexts" tab.

also the tmap logic is as below:

(Load_data.brand_id==context.brand_id_mia && Load_data.country_id==context.country_id && Var.var1 =="Y" && Load_data.productcategory_id ==context.prodcat_mia1)?context.VAT_Reduced_1:context.VAT_Normal_2

the highlighted BOLD part is where i have to pass both the values. the same logic should work for prod category 7 and 8.

Re: How to pass multiple values to a context

sushantk19 — Tue, 07 Jul 2020 12:32:57 GMT

When i run the job with above suggestions , i get the below error:

i have defined a context with name as prodcat_mia1 in "contexts" tab.

also the tmap logic is as below:

the highlighted BOLD part is where i have to pass both the values. the same logic should work for prod category 7 and 8.

tmap_logic_contexts.png

Re: How to pass multiple values to a context

sushantk19 — Tue, 07 Jul 2020 12:41:42 GMT

@manodwhb : also check if the parameter file defination is correct. parameter file is also uploaded.

Re: How to pass multiple values to a context

sushantk19 — Tue, 07 Jul 2020 12:41:42 GMT

@manodwhb : also check if the parameter file defination is correct. parameter file is also uploaded.

contexts_productcat.txt
tinputfile_defination.png

Re: How to pass multiple values to a context

manodwhb — Tue, 07 Jul 2020 12:54:02 GMT

@sushantk19 , you need to use the below way. since productcategory_id is a string data type.

Load_data.productcategory_id.equas(context.prodcat_mia1)