Changing Data Types from an external file

[Sim75]

Hi all,

I am creating a workflow which uses dynamic rename to set the column names to a list. The problem i have not yet overcome is that all of the data when it come in defaults to string. I have a separate file which i am using to set the column names and it also has the data type that i want.

My question is how can I get Alteryx to tell each column what data type i need it to be based on the list in the file?

eg.

Main file has 3x columns with names, IDs and balances

Supporting file has the column names i want as well as the data type it needs to be (Name (String), ID (String), Balance (Double)

 How do I get the data types converted based on the list?

thanks in advance

Simon

[atcodedog05]

Hi @Sim75 

Only way I could pull it off is by using Crew Macros dynamic formula tool.

Here is how you can do it.

Workflow:

Refer to this blog to downgrade the packaged workflow https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/... 

Hope this helps : )