Use context to find excel sheet

[chloeduval]

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é 

[gjeremy1617088143 · Accepted solution]

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.

[chloeduval]

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

Best regard

[gjeremy1617088143]

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.