Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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:
0683p000009MC26.pngThe 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
Labels (2)
1 Solution

Accepted Solutions
vapukov
Master II
Master II

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

View solution in original post

3 Replies
Anonymous
Not applicable
Author

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
vapukov
Master II
Master II

You can add tFlowToIterate and than use global variables in Your job, similar as on screenshot
0683p000009MC2B.png
Anonymous
Not applicable
Author

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