Replace N/A responses with 0 in survey response data

[arundaka02]

Hi everyone

I want to replace 'N/A' responses to a '0' and change the data type from string to a numerical field.

The survey question asks the respondent to record their skill level on a subject and provides the following options:

• N/A
• 1
• 2
• 3

Because of the N/A, Alteryx recognises this data field as a V_string field. By replacing the N/A responses to 0, I then want to change the data type to a numerical field. 

The dataset contains 50+ columns that I need to change.

Can anyone help?

Thanks

KA

[Jonathan-Sherman · Accepted solution]

Hi @arundaka02,

You could use a multi-field formula tool, this allows you to affect multiple columns (and change their data type at the same time)

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[arundaka02]

This is awesome, thanks @Jonathan-Sherman 

I've never used this tool before.