We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
21 - Polaris

@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
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
Top Solution Authors