topic Re: Use context to find excel sheet in Talend Studio

Use context to find excel sheet

chloeduval — Fri, 15 Nov 2024 23:20:49 GMT

Hello

I'm sorry to bother you , I would like to match jobName and excel sheet .

Background : I have a lot of job and I would like to add test . This test are in a excel file and each sheet as the name of a job . I've created a sub-job with a tfileinputexcel on each job.

I've try to vJobParent = JobName on my sub-job and in this job , on the tfileinputexcel for the sheet I using context.vJobParent .

but I've this error

Child job returns 1. It doesn't terminate normally.

Exception in component tFileInputExcel_1 (Jd120_Generique_ChargementTest)

java.lang.RuntimeException: Special sheets not exist!

But my job name and sheet name is the same (copy past used )

If you have an idea ...

Best regard

Chloé

Re: Use context to find excel sheet

gjeremy1617088143 — Wed, 05 Jan 2022 09:48:55 GMT

Hi, if you vJobParent = JobName in the sub job it will take the name of the subjob, if you want to pass the jobName from Parent to child job you have to transmit it in the tRunJobComponent.

Re: Use context to find excel sheet

chloeduval — Wed, 05 Jan 2022 09:57:21 GMT

Oh I'm stupid , thank you so much and sorry to bother you ❤️

Best regard

Re: Use context to find excel sheet

gjeremy1617088143 — Wed, 05 Jan 2022 13:23:39 GMT

don't feel stupid, it's always a pleasure to help people.

If one of my answer help you, you can select it as the best.