Hi, I have below table, My requirement is i want a dropdown with three values :- "APPROVER","CHECKER" and "MAKER". Field1Field2APPROVERCHECKERMAKERAAALLLALEXROBERTJAMESBBBMMMALEXJAMESROBERTCCCNNNPETERROBERTALEXDDDOOOPETERJAMESALEXEEEPPPMAXALEXROBERTFFFQQQMAXALEXPETERJJJRRRMAXALEXJAMES 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 Field1Field2APPROVERCHECKERMAKERAAALLLALEXROBERTJAMESBBBMMMALEXJAMESROBERT PETER.xlsx Field1Field2APPROVERCHECKERMAKERCCCNNNPETERROBERTALEXDDDOOOPETERJAMESALEX ALEX.xlsx Field1Field2APPROVERCHECKERMAKEREEEPPPMAXALEXROBERTFFFQQQMAXALEXPETERJJJRRRMAXALEXJAMES 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!

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

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!

Accepted answers

atcodedog05

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 : )

approver.yxwz

All comments

atcodedog05

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 : )

approver.yxwz

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703