Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Naga
8 - Asteroid

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

1 REPLY 1
binuacs
20 - Arcturus

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

binuacs_0-1647611682065.png

 

Labels