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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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