topic Re: [resolved] ERROR IN GLOBAL VARIABLE in Talend Studio

[resolved] ERROR IN GLOBAL VARIABLE

Anonymous — Wed, 16 Dec 2015 07:00:17 GMT

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.

Re: [resolved] ERROR IN GLOBAL VARIABLE

Anonymous — Wed, 16 Dec 2015 09:39:29 GMT

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_memory-before_loading_data).

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

Re: [resolved] ERROR IN GLOBAL VARIABLE

Anonymous — Wed, 16 Dec 2015 12:46:04 GMT

thanks boss.

Re: [resolved] ERROR IN GLOBAL VARIABLE

Anonymous — Wed, 16 Dec 2015 13:16:29 GMT

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

Re: [resolved] ERROR IN GLOBAL VARIABLE

Anonymous — Thu, 17 Dec 2015 04:27:55 GMT

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.

Re: [resolved] ERROR IN GLOBAL VARIABLE

Anonymous — Thu, 17 Dec 2015 09:13:50 GMT

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.

Re: [resolved] ERROR IN GLOBAL VARIABLE

Anonymous — Thu, 17 Dec 2015 10:33:05 GMT

thanks boss.