Split the excel file based on Client Name and copying that to respective folders

[Naga]

Hi Team,

I need a solution to split the excel file based on the Client name from one column and copy those rows to a template in multiple folders. example

Input data 1 - Client data.xlsx

Client Name 1

Client Name 3

Input data 2 - file path.xlsx

Client Server\folder1\file1.xlsx

Client Server\folder3\file3.xlsx

In fact I can join these 2 data using the client Name as key and get another output like below. However, I need a workflow that actually uses the path name and split the records to the right file.

Client Name                    Path

Client Name 1                 Client Server\folder1\file1.xlsx

Client Name 2                 Client Server\folder2\file2.xlsx

Thanks

Naga

[binuacs · Accepted solution]

@Naga the below workflow will write output in two folders based on the client name