This is actually a job a former co-worker developed. Now I have to do some enhancement on the job.
There is a context variable created within tSetGlobalVar : "store123File"
And the value he put for the variable is: "~/store123.xlsx"
One of the subjobs will read the data from database
-> create the "storeABC" file (tFileOutputExcel: File Name = ((String)globalMap.get("store123File")) )
-> check the existence (tFileExist: File name/Stream = ((String)globalMap.get("store123File")) )
-> send an email with the file attached if file exists
-> delete the file (tFileDelete: File Name = ((String)globalMap.get("store123File")) )
I ran this subjob and the email was sent out with the file attachment. But I don't know where the file is created. I deactived tFileDelete, and ran the job again and search for "store123.xlsx" in my computer, didn't get it.
BTW, my co-worker developed the job with a Mac, I am using PC. I heard that tilde (~) represents user's home directory in Mac. Where should the file be created when I run the job in PC?
Windows do not support ~ as user home folder
if You run job from Studio check inside Studio folder, it will be new folder "~" and inside must be your file
Yes, I ran the job in Talend Open Studio. Could you please let me know how to check a Studio folder?
I still didn't get it. Did you mean I should get the file within my Talend folder? I didn't see it.
Also, if it is in my PC, I should be able to find it by searching the file name, isn't it?
Yes, I ran the job in Talend with tDelete component disabled.
I don't see the "~" within my Talend folder. It is very strange.
But at least I learned that it is not a good idea to put "~" in a directory. It would create a lot trouble for another developer in the future.
Thanks for your help!
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Test drive Talend's enterprise products.