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?
Solved! Go to Solution.
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
Hi @danilang
My data comes from .xlsx.
All the data columns have [Null] - there is none that have a different value.
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.
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