Alteryx Designer Desktop Discussions

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

Change type on multiple rows

Kjaer
8 - Asteroid

Hi

 

Is there a way to change type on multiple rows or do I need to do it one by one?

Here I want to change from V_String to Double in about 500 rows.

 

Kjaer_0-1666105916799.png

 

2 REPLIES 2
binuacs
20 - Arcturus

@Kjaer One way of doing this is with the Multi-Field tool. Attaching a sample workflow. In this example, I changed all numeric to string data types. 

 

binuacs_0-1666106186809.png

 

DataNath
17 - Castor

@Kjaer are these fields bunched together? If so, in the Select tool you can just left-click drag and highlight large sections as shown below, before using the dropdown menus to change all selected. If you need to add individual selections you can also use ctrl+right-click as you usually can when selecting files within a folder in windows etc. and if you need to change the type of all fields or all but a small few, maybe the 'Select All' option below may be best so you can change the type of all fields and then just change a few key ones back to what they should be.

 

Convert multiple fields at once.gif

DataNath_0-1666106342447.png

Labels