Alteryx Designer Desktop Discussions

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

Drop down list in output excel file

Raghu9900
5 - Atom

Hi, I am creating workflow where it requires in the end of the output excel need to create Column and should update the dropdown list as Yes or No for all the line items.

 

Please help me from which tool can be created dropdown list. 

2 REPLIES 2
HomesickSurfer
12 - Quasar

Hi @Raghu9900 

 

Either use the Output Data tool and overwrite range and preserve formatting (keeping Excel cell validation), or; use Blob tools to duplicate a formatted template that contains the Yes/No data validation dropdowns.

FreeRangeDingo
11 - Bolide
11 - Bolide

Can you elaborate more on the Blob option?

Labels