Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

mathias_schnoor
11 - Bolide

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

2 REPLIES 2
DultonM
11 - Bolide

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
7 - Meteor

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

Labels