We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Auto Field Tool documentation needs updated to say that "T", "F" values will be converted

amtraker1777
8 - Asteroid

Auto Field Tool automatically converts F and T values to False and True.  I have no idea why and there is no way to toggle this off.  It says nothing about this in the documentation.  Its documentation needs to be updated to reflect this.

12 REPLIES 12
alexnajm
18 - Pollux
18 - Pollux

Can you just uncheck the column in the AutoField tool so it doesn't get evaluated?

amtraker1777
8 - Asteroid

Yes, but the field I am working with contains a lot of other values beside T and F.  I would prefer Auto Field Tool have a toggle button that I would have to toggle to On that would convert T and F values to True and False.  The default state should be Off.

amtraker1777
8 - Asteroid

Keep in mind the documentation for this tool says absolutely nothing about this conversion logic being built-in.  It required investigation.

alexnajm
18 - Pollux
18 - Pollux

I am not sure I am able to replicate this behavior, can you post a sample workflow showing this? Here is my attempt:

apathetichell
20 - Arcturus

I think I saw this on some versions of Atleryx --- and as I remember it --- it only occurred in fields with values of null/T or F ---> and basically it said that a boolean value took up less memory than a string. 

alexnajm
18 - Pollux
18 - Pollux

Ah @apathetichell , then that makes sense to me!

 

@amtraker1777 uncheck the box and you should be good - it makes sense that the Auto Field tool would evaluate those as boolean, although yes it should probably be better documented.

amtraker1777
8 - Asteroid

Better documentation? There is nothing about this in the documentation. It needs to be added or else other could fall victim to this like I did.

amtraker1777
8 - Asteroid

Even though there were at least 40 other distinct values besides T and F, it still changed the T and F values.  I can understand if there were only T, F and Null values, but in my case there were a lot of other values besides T & F, some even being multiple characters in length.  It makes no sense to me why it would do this.

alexnajm
18 - Pollux
18 - Pollux

Can you give us a sample then to play with? It may be just a defect if we are unable to replicate the behavior

Labels
Top Solution Authors