[resolved] ERROR IN GLOBAL VARIABLE

[Anonymous]

i have a scenario.
i have to get max date from 'pat_full_info' and i need to add global variable using 'tFlowToIterate_1' and i need to use that global variable in 'patient' and 'doctor' tMysqlInput components (in query) to filter data and i need to map filtered 'patient' and 'doctor' data using tMap and insert or update that data into output table(tMysqlOutput_1).
Look into my job.
I created one global variable using 'tFlowToIterate_1' and i linked to 'patient' and 'doctor'.Till now ok.
But when tried to map 'patient' and 'doctor' to tMap,i am able to map only one table either 'patient' or 'doctor' but i need to do for both tables.
i have attached screenshot also.
Help to solve how i can accomplish my task.

[Anonymous · Accepted solution]

You cannot split a flow and rejoin it in a single subjob. The way to do this is to output to tHashOutput for both Parent and Teacher, then in a new subjob use connected tHashInput components to join the data in a tMap. An example of using tHash components is here ( https://help.talend.com/pages/viewpage.action?pageId=8123271#technical-thashinput-scenario_clearing_...).

This might mean you will need to change your globalMap usage to accommodate this.

[Anonymous]

thanks boss.

[Anonymous]

You need two tHashInputs; one for your Student data and one for your Teacher data. 

[Anonymous]

hi boss,
i did same as you told but if i use two 'tHashInput' also i am not able to establish link between 'tHashOutput' to 'tHashInput'.

Here i am not able to establish two 'tHashOutput' components to 'tHashInput' components.

Is there any way i can alter my JOB to solve my problem.

Link into the screenshot and do what i can do to solve this.

[Anonymous]

In the tHashInput components, look for the "Component List" drop downs. That is how you "link" your output components to your input components. You will also need to make sure the schemas are the same.

[Anonymous]

thanks boss.