Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Auto Field doesn't convert to Boolean

StefanusJPK
6 - Meteoroid

 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.

StefanusJPK_1-1625148927772.png

 

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.

 

StefanusJPK_0-1625148890324.png

Can someone help me?

6 REPLIES 6
danilang
18 - Pollux
18 - Pollux

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
6 - Meteoroid

Hi @danilang

 

My data comes from .xlsx.

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

danilang
18 - Pollux
18 - Pollux

Hi @StefanusJPK 

 

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

 

Dan

StefanusJPK
6 - Meteoroid

Hi Please find attached

ArtApa
Alteryx
Alteryx

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:

ArtApa_0-1625172134829.png

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

ArtApa_1-1625172238816.png

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.

ArtApa_2-1625172311600.png

 

 

StefanusJPK
6 - Meteoroid

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

Labels