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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Can I use tMap to filter folders from a FTP server?

I wanted to copy certain folders from a FTP server to my local computer.

Here is the Talend components I used:

0683p000009Lz3z.png

1. tFTPConnection

2. tFTPFileList       -- with the filemask in tFTPFileList, I was able exclude some unwanted folders. In order to exclude all the unwanted files, I used another 2 components:

 

3. tIterateToFlow:

    filename: ((String)globalMap.get("tFTPFileList_4_CURRENT_FILE"))     -- in this case, the filename is the folder name

    filepath:   ((String)globalMap.get("tFTPFileList_4_CURRENT_FILEPATH"))

4. tMap:    

    use a filter to exclude unwanted file:  !row9.filename.equals("here is the unwanted folder name")

 

Now if I link tMap's output to tLogRow, I can see the unwanted filenames (folder names) are all gone.

 

But my question is, how to copy the correct foldes after tMap? Can I just connect tMap to tFTPGet? What should I  do now?

 

Thanks!

Labels (2)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

link tMap to a tFlowToIiterate to iterate each folder, eg:
...tMap--tflowToIterate--iterate--tFTPGet.

View solution in original post

3 Replies
manodwhb
Champion II
Champion II

@Moe,from tMap,wirite it it file ,tHashOutput or DB and again read that file and iterate the values and in tFTPGet call that global variable form iterated value as file-mask.

Anonymous
Not applicable
Author

link tMap to a tFlowToIiterate to iterate each folder, eg:
...tMap--tflowToIterate--iterate--tFTPGet.
Anonymous
Not applicable
Author

Thank you shong!  It worked.