Blank record causing column name to not display

[sucansa]

Hi,

I have a use case to show the total pass, fail and Null records.. But there are some blank records in a column. That is causing the column name to not appear in the output..

Example: If Account Number column has blank records(Not Null records but blank records), Account Name has 10 Pass records, 5 fail records from Table A, My output is having Table A with blank column for "Account Number"(not displaying column name, but just blank) and Account Name with 10 Pass and 5 Fail..

My question is how to make Alteryx display column name inspite of blank records. I don't mind if it shows a single record as Null.. I am using transpose and Summarise tool to display the counts of a value in columns

[wdavis]

Hi @sucansa 

Could you try putting a Data Cleansing or Formula tool before Transposing your data, to replace those blank values with a Null or a 0? So that it recognises that their is information within that field?

Kind Regards

Will

[sucansa]

Myabe I should rephrase my question- There is no record for that column. Because of which the column name is not appearing in my output. Is there a way I can add dummy null value record to the column so that I get the column name in my output?

[wdavis · Accepted solution]

@sucansa 

If you use a Formula tool before your output you can 'Add a new column' - If you name this, to what you would like your field header to be. Then in the Value for that field you could just enter "" which will provide an empty value for each record.

Would that work?

Regards

Will

[sucansa]

yeah it works. Although I felt like it is kinda hard coding.. Was looking for something to enter something for empty records. So that column name is not missed.