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!
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.