This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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:
@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.