Dynamic filter and have them pasted in different excel files

[Naga]

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_col	source		Filter_col	source		Filter_col	source
a		a	1		a	1		c	2
b		c	2
c		d	3
d

Thanks

Naga

[Naga]

Anybody can help

[binuacs · Accepted solution]

@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

[Naga]

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