Auto Field doesn't convert to Boolean

[StefanusJPK]

 Hi, My data for some reason imports various rows as Null.

I want to use auto field to change the fields to Boolean and then use a dynamic select to remove the fields.

The atofield changes my data to "Double" for some reason.

I do not want to use a select because the information I receive can vary from time to time and sometimes it might not create extra fields - I just want to input the data and have the same output.

Can someone help me?

[danilang]

hi @StefanusJPK 

Where is your data coming from?  When I try this with a CSV file, fields that are completely empty are converted to boolean fields(see attached).  Make sure that your input data doesn't have a non null value somewhere.  Add a summary tool after your input and use the Count non Null function on the suspect columns

Dan

[StefanusJPK]

Hi @danilang

My data comes from .xlsx.

All the data columns have [Null] - there is none that have a different value.

[danilang]

Hi @StefanusJPK 

Can you post your Excel file?  Or even just enough to demonstrate the issue?

Dan

[StefanusJPK]

Hi Please find attached

[ArtApa · Accepted solution]

Hi @StefanusJPK - So what is your goal? Remove the fields dynamically?

1) You can use a Data Cleansing tool, which will remove all null columns for you:

2) You can use a formula in your Dynamic Select to remove column based on name:

3) There are a few more ways how you can do this.

If you still need to convert these fields to Bool, I added a workflow for you.

[StefanusJPK]

Hi @ArtApa 

It seems that I have a older version of Alteryx as I do not have the option of "Remove Null Columns".

However, the Dynamic Select Formula has done the job 😁!

Thank you so much!

StefanusJPK