How to connect multiple FTP locations in the same job

[Anonymous]

I have one table which contains many distributors and retailers ftp connection details.

The table structure is as follows:

Dist_Id       Reta_Id        Ftp_host       Ftp_user        Ftp_pswd
------------------------------------------------------------------------------------
1                 a                   123               abc                 xyz
1                 b                   456               def                  mno
2                 c                   431               ghi                  p9r
3                 d                   789               jkl                   12e

So for getting all files for Dist_Id=1, I want to connect ftp locations of Retailers a and b. And download files in each ftp location to the same folder.
How can I connect to multiple ftp locations and download files in the same folder??

[Anonymous]

Hi,

I have one more block to complete this job..

While using context variable context.FTP_Files  as Filemask in FtpGet component,  it did not download files when more than one file name are provided in the FTP_Files column separated by comma.But downloads when only one file name is provided. How can I download all the files provided in the FTP_Files column?? 

Example: 

Dist_Id            Reta_Id             FTP_Files

---------------------------------------------------------------

 1                     a                       ab.csv,mn.csv

 1                     b                        pq.csv

In this case, for Dist_Id=1, context.FTP_Files only download pq.csv. Actually I want to download all these 3 csv files in the same folder.. (Dist_Id is same).

Thanks In Advance..

[fdenis]

filters are list you cannot dynamically convert strings to list.
so you have to use a tNormalise to split your file liste.

[Anonymous]

Neena, 

below is the job with tNormalize as Denis suggested.

row 1 - settings:

tNormalize - component settings 

 Output

Input

Regards,

Ragu

[Anonymous]

Thanks for both of you.. It Works...

[Anonymous]

Hi,

I have one more doubt.. 

When I download all retailer files and inserted to one common table, it can not distinguish which data is getting from which Retailer.. So I want to append one column(Reta_Id) in all csv files when the file is downloaded from ftp location. Is it possible to append a column in csv at the time of downloading from FTP??

Thanks In advance

[fdenis]

yes you can but you have to download then open and add column.

[Anonymous]

Thanks for your reply...

I want to add the Retailer_Id column in each file when it is downloaded.. Then only corresponding Retailer_Ids can be added.  Since there are many files Manually open and adding  the column is not possible..