Alteryx Designer Desktop Discussions

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

How can I change data types dynamically?

Korpelak
8 - Asteroid

Hello, is there a way to dynamically change the data types for a data source based on the field types from another data source? Like using the output from field info tool?

 

Thanks,

Karina

3 REPLIES 3
Claje
14 - Magnetar

Hi,


The CReW Macro "Dynamic Metadata" supports exactly what you are looking for.

 

If you configure it to take Metadata from Source Input Rows it will convert each field's type and size based on the Source data (say, from a Field Info tool).  This does a match on field names, so you will want to make sure these are identical beforehand.

Korpelak
8 - Asteroid

Thanks!

CharltonFranklin
8 - Asteroid

@Claje I don't understand the first part of your solution

If you configure it to take Metadata from Source Input Rows


What is "it" that needs configuring?

Labels