Alteryx auto reading a field to be Numeric and returning Null value for text

atul_maskara

I have a data in excel which has more that 400,000 records. A particular field in the data is a alphanumeric field where first few thousand fields are numeric and then there is a mix bag of numeric and alphanumeric data. When inputting the file in Alteryx it is automatically detecting the field as numeric and even after using Select tool and changing the data type to String is not working. All the numeric values are converting to string and displaying in output, however all the text data (alphanumeric data) are returning Null in the output.

atcodedog05

Hi @atul_maskara 

Try something like this.

Configure First row contains data

By this all column will be taken as strings

Configure dynamic rename tool to take name from 1st row like below.

Load your file to the attached workflow and check. And set the datatype as required

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

datatype.yxmd