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

Question

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 Answer

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.