Hello All I am new on Alteryx. Here I am doing data completeness task under which want below output .. want to get final output as below showing in excel in Alteryx. Please Help, It's Urgent Coulmn1Value under Column1Total RecordsNull Value RecordsNot Null Value RecordsChannelChannel1312ChannelChannel2404ChannelChannel3624ChannelChannel4321ChannelChannel5413StateState1624StateState2312StateState3532StateState4202StateState5413 Please Share Workflow if already available or Please Suggest or if anyone have best flow or complete output to know data completeness.. please share link, file.. Thanks in advance.. please help Thanks Alok Sachan

Need to know Channel and Its Variable Null Values in Data Completeness

Hello All

I am new on Alteryx.

Here I am doing data completeness task under which want below output

.. want to get final output as below showing in excel in Alteryx.

Please Help, It's Urgent

Coulmn1	Value under Column1	Total Records	Null Value Records	Not Null Value Records
Channel	Channel1	3	1	2
Channel	Channel2	4	0	4
Channel	Channel3	6	2	4
Channel	Channel4	3	2	1
Channel	Channel5	4	1	3
State	State1	6	2	4
State	State2	3	1	2
State	State3	5	3	2
State	State4	2	0	2
State	State5	4	1	3

Please Share Workflow if already available or Please Suggest

or if anyone have best flow or complete output to know data completeness.. please share link, file..

Thanks in advance.. please help

Thanks

Alok Sachan

Workflow

Datasets

Developer

Data Investigation

Accepted answers

All comments

DataNath

Hey @alokkrsachan, in the Summarize tool, you're able to do counts, including with/without nulls and so it sounds like that's exactly what you need. For your case you'll just need to Group By whatever is required for you own use:

Before:

After:

Count + null + non-null count.yxmd

alokkrsachan

Thanks DataNath,

Please help me to get output exact same as shared in excel please

PaulJasonMackjoo

Hi Alokkrsachan,

Can you please share the data input?

DataNath

@alokkrsachan to output to Excel, you just need to bring an Output Data tool onto your canvas and click the first arrow to bring up the different output types. From there you can simply select .xlsx, select a file location and a name for your output. After you've done that, just run your workflow (Ctrl+R is a keyboard shortcut) and Alteryx will write the file.

Output to Excel.png

Count + null + non-null count - updated.yxmd

Emmanuel_G

Hi @alokkrsachan ,

To generate your output data, you can use the export tool as in the workflow below.

Unless your concern is that you can't get the output you showed us. In this case, please provide us with the file from which we can test.

Let us know if it works as you want.

Cheers !

Output excel file.yxzp

alokkrsachan

Hi Emmanuel_G,

Thanks for Respond, Attaching here below Input File...

Please Check & Help..

Thanks

Alok

Alteryx Sample Data.xlsx

DataNath

@alokkrsachan after something like this? Some of your product names are null hence those categories. If not, can you tell us the desired outcome from the Excel file you provided?

Null and non-nulls.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703