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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
ar7368
Contributor
Contributor

File Transfer

Hi,
I have a job to modify filenames of files(pdf) from source with static data inserted in the fourth component of file name such that it will have the following format
TAC_CAT_time/date_Op2_uniqueID.pdf. The filenames will already contain TAC_CAT_DATE_unique ID.pdf. thus Op2 (case sensitive) is missing. The TAC and CAT components are 8 and 9 characters long respectively. I have figured out all of the above, except that when the MRN or HAR are not within 8 or 9 characters long i need to generate a error. Sometimes these components are keyed in wrong by users. How do I filter these files? to generate a email.
So in effect the 28th character in my filename needs to "_".
Labels (2)
22 Replies
Anonymous
Not applicable

Hi
I have received your email.
Let's say the specified source directory is "E:/TOS_DI-r75219-V5.0.1NB/workspace/".
You can set source filename of tFileCopy as the following images.
Use row2.columnname to define destination name instead of tFileList_1_CURRENT_FILE.
Regards,
Pedro
ar7368
Contributor
Contributor
Author

Thanks Pedro. The job works now.
I left the tfilecopy source name to tfilelist_current_filepath and altered the destination rename to "row2.filename".
_AnonymousUser
Specialist III
Specialist III

Long Path Tool helped me in this situation. http://PathTooDeep.com 0683p000009MACn.png