Split and save the excel file into different name based on column value

[alt_tush]

Hi,

I have below table, My requirement is i want a dropdown with three values :- "APPROVER","CHECKER" and "MAKER".

Field1	Field2	APPROVER	CHECKER	MAKER
AAA	LLL	ALEX	ROBERT	JAMES
BBB	MMM	ALEX	JAMES	ROBERT
CCC	NNN	PETER	ROBERT	ALEX
DDD	OOO	PETER	JAMES	ALEX
EEE	PPP	MAX	ALEX	ROBERT
FFF	QQQ	MAX	ALEX	PETER
JJJ	RRR	MAX	ALEX	JAMES

If i select the "APPROVER" from dropdown the data should splitted/filter into 3 "ALEX","PETER" and "MAX" and three excel file should generated.

ALEX.xlsx

Field1	Field2	APPROVER	CHECKER	MAKER
AAA	LLL	ALEX	ROBERT	JAMES
BBB	MMM	ALEX	JAMES	ROBERT

PETER.xlsx

Field1	Field2	APPROVER	CHECKER	MAKER
CCC	NNN	PETER	ROBERT	ALEX
DDD	OOO	PETER	JAMES	ALEX

ALEX.xlsx

Field1	Field2	APPROVER	CHECKER	MAKER
EEE	PPP	MAX	ALEX	ROBERT
FFF	QQQ	MAX	ALEX	PETER
JJJ	RRR	MAX	ALEX	JAMES

Same should be executed if i select the "CHECKER" or "MAKER". So data should be splitted or filter accordingly and file should be generated. If i select "CHECKER" then file should be ROBERT.xlsx, JAMES.xlsx and ALEX.xlsx

Please help!

Thank you!

[atcodedog05 · Accepted solution]

Hi @alt_tush 

Here is how you can do it. We can supply selection value to formula tool and change the column selection for filename generation.

Workflow: Column selected approver 

Column selected maker:

Hope this helps : )

[alt_tush]

HI atcodedog05,

Thank again 🙂

Its work 🙂 Thank you so much for your quick response 🙂

Really appreciate it.

[atcodedog05]

Happy to help : ) @alt_tush 

Cheers and have a nice day!