Macro Input Tool: configure input field types with defined data types

[mathias_schnoor]

Hi!

How is it possible to configure input field types with defined data types by the Macro Input Tool > File Input?

My input file is a csv file.

When I use Macro Input Tool> Text Input

Forr example:

I setup one row: (The Field Map Display )

1 for byte (Int)

1.1234 for Double

'abc' for String


But if my row has the same setup in my csv file and I use Macro Input Tool > File Input the Field Map Display I get always the data type string.

How is my bug?

Mathias

[DultonM · Accepted solution]

Hi @mathias_schnoor!

Unfortunately, Alteryx reads all fields from a CSV as a string format (regardless if you use the dynamic input, input, macro input, etc.). Hopefully, you can use a Select tool in the workflow prior to the macro to format fields in the appropriate way before the data enters the macro.

[Itay_K]

Hi,

Is there a new solution for that issue?

I'm looking to fully automate a process and currently the issue is limiting that option.

Thanks