Problem in Identifying Data Types

dineshp

Hi,

Alteryx is not recognizing a field with varied character length to be a V_String even though the length is greater than 16. This is leading to padding trailing spaces when writing into a SQL table. Even 'Auto Field' tool is not identifying this data type.

Version: v11.7.4.4

Below examples should be V_String so that trailing spaces are not padded but instead it shows it as String. I can manually convert this to a V_String using Select tool but the length needs to keep changing depending on the refresh period.

Thanks!

MichalM

The select tool will not dynamically change the length but should persist anything that the Autofield identified - the longest string.

In your case, you have a field with mixed width. Autofield is going to identify the longest string (width 17) however will not set the data type to V_String as it should. If you add a Select tool after the Autofield and change the data type from String to V_String, the width of the column should stay unchanged - 17.

Another way to do this would be by wrapping a Select tool into a batch macro and passing the desired width and data type through the control parameter after you obtain it dynamically from the workflow upstream.