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

Dynamic filter and have them pasted in different excel files

Naga
8 - Asteroid

Hi All,

 

I need the help in the following problem. I have a dynamic requirement of filtering the value in one excel and copy to another excel as output.

 

Filter records should file value from Input and split them into File 1 & File 2

 

  Input  File 1  File 2 
Filter Filter_colsource Filter_colsource Filter_colsource
a a1 a1 c2
b c2      
c d3      
d         

 

Thanks

Naga

 

3 REPLIES 3
Naga
8 - Asteroid

Anybody can help

binuacs
20 - Arcturus

@Naga The output tool has the ability to save the files in different names based on a column value. Attaching the sample workflow for your reference. In the given example the workflow saves three files with the name of the filters a, c, d and only contains those records

 

binuacs_0-1675979961501.png

 

Naga
8 - Asteroid

@binuacs - Much appreciated. Thanks for this solution and it helped. 

Labels