Blank record causing column name to not display

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

Data Investigation

Accepted answers

wdavis

@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

All comments

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?

test.PNG

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703