Worklflow output records count into Excel table

Rudy2020

Hi all,

I'm new to Alteryx.

I've managed to create a workflow which applies set of conditions to filter the data and I've managed to output the data into one Excel file - each Excel tab now includes the data for each condition.

The challenge I'm struggling to figure out: Rather than having the underlying records/data for each condition being output into Excel, I would like to create and Excel file showing a simple table of the total count of records for each condition, e.g.

Condition 1	Condition 2	Condition 3
156	58	64

Any help will be appreciated.

Thanks.

Workflow

Output

Accepted answers

grazitti_sapna

Hi @Rudy2020 , I am assuming that everything is sorted for you already just gave you a way out to get columns together in a single file, please refer to the screenshot if this is what you are refering to? Also, just wondering it would be great if you could simply provide a sample of the output that you are getting from the workflow that you created.

All comments

RobertOdera

Hi, @Rudy2020

It would be helpful to see your workflow sample before you output to tabs on the same excel file.

However, if I'm following this correctly, you have data summarized into a group by Conditions + count of Conditions met.

Try using the Append Fields Tool or you can use the Transpose Tool + Cross Tab Tool combo.

Cheers!

Rudy2020

Hi @RNO2

Please see the flow below. As you can see, I have 8 outputs (filtered data) into separate Excel tabs.

What I'm trying to achieve is for Alteryx to create 1 Excel file with a simple table which has 8 columns. First row to include headings and the second row to include count of records for each of these 8 outputs.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335