Dynamic filter requirement help

Question

Hi All,

Good day. I have a very dynamic requirement.

I got 2 files one has the Client data and other one have the client name. I have to filter the client name basis the list to the Client Data save that to a different folder for each Client as a excel file. Though the requirement doesn't end with this, however, getting here can make to me move further.

Thanks
Naga

Naga · Answer

Hi @atcodedog05,

Thanks for your quick response. I will use this one will be a good solution when I move on. Giving your more background. I have created a master mapping file that will be used to find the input and the output paths for each Client. The flow should transfer all those files to different path based on the mapping file. I am also trying to use joins, but not sure if we have any other best way.

1st step what I am try to look is for a solution that will fetch the Client records basis the Client name in the mapping file. This mapping is defined for a year that will run weekly to fetch the client records from each file and move that to respective client paths. I just need looking for a prototype that will fetch the records based on the mapping file.

Trying to achieve input from single path every week to 100's of different path as output.

Please let me know if you have any proposed solution to meet this need.

Thanks again for your support

Thanks
Naga

atcodedog05 · Answer

Hi @Naga

Here is how you can do it. I have taken an example where I want to split files on region. What you should is

1. Create output file fullpath.

2. Configure output tool to write to the path.

Workflow:

Hope this helps : )

customer.yxmd