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

Auto Field Tool

AustinRiggs94
8 - Asteroid

Hi All,

 

I have been under the impression that the auto field tool acts as an auto fit tool for columns.. is this correct? If so, i have been trying to use it and have had no luck. I have followed about all guides in the community. Please let me know, thanks for the help

8 REPLIES 8
tcroberts
12 - Quasar

Yes, it chooses the smallest data type for each field in your data stream.

 

Could you provide some more information about what you're trying to do, the output you're getting, and what the issue is?

 

Cheers

AustinRiggs94
8 - Asteroid

Alteryx Auto Field tool.JPG

Thanks for replying,

 

I have columns that contain both V_String and Double (see attached). What i would like is the output to have "autofitted" columns instead of me using a macro in Excel. However this the result i get when i use the auto field tool.

 

 

I am probably misusing the tool but wanted clarification, thanks.

tcroberts
12 - Quasar

Sorry I'm not really sure what I'm supposed to be seeing in those documents. As far as I can tell they are identical. Could you explain a little more what you were expecting to happen, and perhaps provide a small  'made up' dataset that illustrates it?

KOBoyle
11 - Bolide

When I have heard the term autofit with Excel and other tools, it refers to column width and adjusting the width so the widest value is visible. The Auto Field tool sets the smallest data type and field size. That is not the same thing. The purpose of the tool is to reduce resource consumption and improve workflow performance. In some cases it will also update a field initially interpreted as a string type to a numeric type. In your case it is simply shortening the string size as the number fields were interpreted correctly as Double. You can see this be clicking on Metadata in the Results pane. The Auto Field tool will not affect how Excel behaves.

 

 

Input Metadata

 

Auto Field 1 2018-11-2018.png

 

Auto Field Metadata

 

Auto Field 2 2018-11-2018.png

 

 

AustinRiggs94
8 - Asteroid

That makes perfect sense. Thank you for the help.

Is there a way to extract/export the metadata output from the auto field tool? 

Thanks is advance!

apathetichell
18 - Pollux

Field Info tool creates the metadata from the auto field tool in your workflow - note, it includes non-autofield types ie numeric types.

Thank you! It worked.

Labels