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.
Solved! Go to Solution.
Can you just uncheck the column in the AutoField tool so it doesn't get evaluated?
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.
Keep in mind the documentation for this tool says absolutely nothing about this conversion logic being built-in. It required investigation.
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.
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.
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.
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.
Can you give us a sample then to play with? It may be just a defect if we are unable to replicate the behavior
User | Count |
---|---|
63 | |
28 | |
23 | |
22 | |
22 |