Auto Field doesn't convert to Boolean

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?

Preparation

Accepted answers

ArtApa

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.

BooleanAA.yxmd

All comments

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