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

[alokkrsachan]

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

[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:

[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.

[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 !

[alokkrsachan]

Hi Emmanuel_G,

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

Please Check & Help..

Thanks

Alok

[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?