Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

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

alokkrsachan
7 - Meteor

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 Records
ChannelChannel1312
ChannelChannel2404
ChannelChannel3624
ChannelChannel4321
ChannelChannel5413
StateState1624
StateState2312
StateState3532
StateState4202
StateState5413

 

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

7 REPLIES 7
DataNath
14 - Magnetar

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:

 

DataNath_0-1657283150010.png

 

After:

 

DataNath_1-1657283171741.png

alokkrsachan
7 - Meteor

Thanks DataNath,

 

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

PaulJasonMackjoo
5 - Atom

Hi Alokkrsachan,

Can you please share the data input?

DataNath
14 - Magnetar

@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

DataNath_0-1657357830345.pngDataNath_1-1657357866103.png

Emmanuel_G
13 - Pulsar

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 !

Emmanuel_G_0-1657361719630.png

 

alokkrsachan
7 - Meteor

Hi Emmanuel_G,

 

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

 

Please Check & Help..

 

 

Thanks

Alok

 

 

DataNath
14 - Magnetar

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

 

DataNath_0-1657367612940.png

 

Labels