topic Re: Creating xml file by passing parameter in runtime in Talend Studio

Creating xml file by passing parameter in runtime

_AnonymousUser — Tue, 12 Jan 2016 11:13:15 GMT

Hi,
Suppose we have following tables (Company,Project,Client Project,Internal Project,Project Details,Manager,Employee Details).Those tables have parent child relationship.
Company --> Project --> Client Project --> Project Details --> Manager --> Employee Details
Will give the employee details for client projects.
Company --> Project --> Internal Project --> Project Details --> Manager --> Employee Details
Will give the employee details for Internal projects.
Now if I pass "Project" as parent and "Client Project" as child in runtime.It will invoke
Project --> Client Project --> Project Details --> Manager --> Employee Details branch and create one xml file.
Or if I pass "Project" as parent and "Internal Project" as child in runtime.It will invoke
Project --> Internal Project --> Project Details --> Manager --> Employee Details branch and create one xml file.
Either way if I pass company as parent and project as child in runtime. It will invoke all the information related to client project as well as internal project and store it in a xml file.
I am to pass those parameter (i.e Project, not any value related to project -->Project_id or Project_name etc) in run time and it will create xml file accordingly.
Thanks
Babul

Re: Creating xml file by passing parameter in runtime

_AnonymousUser — Tue, 12 Jan 2016 12:19:29 GMT

Hi,
Is there any way ??
Please help me .

Re: Creating xml file by passing parameter in runtime

Anonymous — Wed, 13 Jan 2016 08:23:18 GMT

Hi,

Suppose we have following tables (Company,Project,Client Project,Internal Project,Project Details,Manager,Employee Details).Those tables have parent child relationship.
Company --> Project --> Client Project --> Project Details --> Manager --> Employee Details
Will give the employee details for client projects.
Company --> Project --> Internal Project --> Project Details --> Manager --> Employee Details
Will give the employee details for Internal projects.
Now if I pass "Project" as parent and "Client Project" as child in runtime.It will invoke
Project --> Client Project --> Project Details --> Manager --> Employee Details branch and create one xml file.
Or if I pass "Project" as parent and "Internal Project" as child in runtime.It will invoke
Project --> Internal Project --> Project Details --> Manager --> Employee Details branch and create one xml file.
Either way if I pass company as parent and project as child in runtime. It will invoke all the information related to client project as well as internal project and store it in a xml file.
I am to pass those parameter (i.e Project, not any value related to project -->Project_id or Project_name etc) in run time and it will create xml file accordingly.

Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina