topic Re: [resolved] How to use a dynamic parameter in Tsystem component in Talend Studio

[resolved] How to use a dynamic parameter in Tsystem component

Anonymous — Tue, 25 Oct 2016 10:55:38 GMT

Hello,
I need to create a new directory on a distant server for each new user created by my Talend JOB.
Its seems that Tsystem component is the most appropriated for this operation.
Temp_Ldap_New table provides new users is (out3.sn) and i want tSystem_1 component to create a new folder named withe the value of out3.sn for each out3.sn:
The issue is that tSystem_1 component creates the Folder on Z server but with null as name instead of the value of out3.sn.
Any idea on how to create the folders with the correct name ?
Many thanks for your help.
Best Regards
Christiane

Re: [resolved] How to use a dynamic parameter in Tsystem component

Anonymous — Tue, 25 Oct 2016 11:57:09 GMT

Hi
Use a tFlowToIterate to iterate each row, eg:
...tMap--out3--tFlowToIterate--iterate--tSystem
on tSystem:
"cmd /c mkdir Z:\\"+(String)globalMap.get("out3.sn")
Regards
Shong

Re: [resolved] How to use a dynamic parameter in Tsystem component

vapukov — Tue, 25 Oct 2016 12:01:33 GMT

You can add tFlowToIterate and than use global variables in Your job, similar as on screenshot

Re: [resolved] How to use a dynamic parameter in Tsystem component

Anonymous — Tue, 25 Oct 2016 12:46:04 GMT

Hello!
It Works fine !! many thanks for you help! have a nice day.
Regards,
Christiane