How to make Data validations in Alteryx similar to excel

Hi,

I want to create Data validations similar to excel. Refer below screenshot for better understanding :

After clicking on OK, the highlighted cell can only have values which i have specified like below :

Alteryx community Q Snap.png

I want similar validation to be applied on column in Alteryx generated output excel. I know I can do this manually but next day again output file will be over written or new file created and then I will again i have to do this. Is there any way to avoid this doing manually daily ??

Thanks in Advance !!

Workflow

Input

Output

Tips and Tricks

Parse

Common Use Cases

Transformation

Data Investigation

Accepted answers

Christina_H

I don't think Alteryx can create Excel data validation, but you can maintain it using the Preserve Formatting option

For this to work, you need to specify the range you are exporting to

I've tried this with some test data, and the data validation remains when the data is overwritten (although you can export something that doesn't meet the validation conditions)

All comments

MichelleMitchellLutz

Hi @Akshay93 ,

I'm not aware of Alteryx / Excel validation functionality. However, you can build a self-service application. I have a process where a report is generated, the user makes modifications, then uploads the modified report. A second report is then generated (based on her modifications) and sent to her. Would something like this work?

Another option would be to provide all of the drop down validation items in a row with pipes, and the user can delete the ones they don't need (e.g., one|two|three) etc.

Christina_H

I don't think Alteryx can create Excel data validation, but you can maintain it using the Preserve Formatting option

For this to work, you need to specify the range you are exporting to

I've tried this with some test data, and the data validation remains when the data is overwritten (although you can export something that doesn't meet the validation conditions)

Akshay93

Thank you Michelle For your time.

The first part related to report upload will not work as I wanted validation in the WF output itself.

Good idea related to pipe. But again in that case manual work remains.

I guess keeping formatting in output file works as in that case it would be only once that I need to make that validation in excel.

Akshay93

Hi @christina_H - Thank you for your time.

Yes, preserve formatting option shall work for this. It would be only once that I will need to add validations.

Thanks for the idea !!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703