This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm trying to create a fully automated process which transposes fields prior to an autofield. As such, I've had to use a Multi-Field formula on all fields to replace all nulls and blanks with null as below. However, the autofield still isn't picking up one of my fields as numeric. I can't select this manually as the data will change each time it is imported.
Has anybody experienced this before or can anybody help?
IF (Isempty([_CurrentField_]) OR ISNULL([_CurrentField_])) THEN NULL() ELSE [_CurrentField_] ENDIF
@FrederikE@michelle_mathews The problem I would have with the above is I have a dynamically changing number and type of fields, so I won't want to strip out letters from all string fields - so I don't think I'll be able to use the datacleansing or multi-field tools in this case unless I can apply it to all fields... I think I'm stuck as I'm fairly confident there are no rogue letters in that field as the original input data recognised as a double.
There has got to be something non-numeric in your records to prevent the Auto Field tool from recognizing the field as numeric. Is the issue that it is then not passing to Auto Field since Auto Field only works on strings?
If you're not able to resolve, I can think of one possible workaround. You could use RegEx to identify your numeric vs. non-numeric fields and then force the data type with a Select tool (with Dynamic / Unknown option).
Let us know what you find out. I'm curious as to the resolution.