Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

Dynamically change the field type based on a config table

Pliew
6 - Meteoroid

I have a large number of raw files to ingest the data into an SQL database. As each of the tiles is different, would need a way to dynamically change the field type based on a config file (Result from using 'Auto Field' tool is not perfect) . Wondering if it can be done in Alteryx.

* 'data' tab, sample data

* 'config' tab, detail on the required field type 

chutchison3
5 - Atom

Here's a related solution using dynamic select and multi-row formula to change data types.

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamically-Change-A-Field-Type/td-p/3...

Pliew
6 - Meteoroid

That does not work.

In my case, the relationship between the auto-generated field type and the required field type is not constant from one file to another.

The change of the field type needs to map with the config tab to the get required field type.

 

Labels