Output separate excel files removing blank columns

Hi,

I am taking my input file below and then output to individual excel workbooks based on the Company. The issue I am running into is my output is including the Corp column that is not associated with the Company. Is there a way to remove blank columns in my output?

There are many more Companies and Corps, this is a small sample. Ideally, I wouldn't want to setup individual formulas/select/filter tools

Thanks for any feedback!

Input:

Current: Output to 2 separate excel file

Goal: Output to 2 separate excel files without B Corp column showing up in Company A (and vice versa, without A Corp showing up in Company .

Input

Output

Accepted answers

jdminton

Hopefully the macro is included in the package, but this should do what you need. Take a look and mark as a solution if it works for you.

Corp Outputs.yxzp

Output Macro.yxmc

All comments

acarter881

Hello, @asiu.

One idea is to use a batch macro in which you provide the company names to the Control Parameter and the workflow will loop over the company names (such as by changing the company to filter for in a Filter tool), each iteration outputting a different company Excel file.

Here's a helpful article on getting started with batch macros: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/Getting-Started-with-Batch-Macros/ta-p/488165

binu_acs

@asiu as @acarter881 mentioned you need a batch macro for your use case. Attaching a sample workflow which will create two excel output files based on the company name and remove the unnecessary fields.

Screenshot 2023-07-14 204824.png

Company_140712.yxzp

asiu

Thank you for sharing the workflow!

I tried running the workflow and only 1 output (Company A) appeared. I am tracing it back to the Filter where it is set to Company = Company A and was wondering if that was the reason why I am only getting 1 rather than both files.

jdminton

Is there a reason that you need it to say "Corp A" or "Corp B" as the column header for the output? The attached will work without having to create a macro.

Corp Outputs.yxmd

asiu

Yes, I need Corp A and Corp B as headers. The full set of data will have multiple Corps (e.g. Corp A-1, Corp A-2). Thanks!

jdminton

Can you provide some additional data? The output you provided shows that each Corp will have its own Excel file and 1 column. I'm not sure what you're trying to get to overall. I'm guessing it will just be a modification of what I sent before.

asiu

Yes, please see below. The main issue I am having is making sure none of Corp As are appearing in Company B's file (and vice versa, non of Corp Bs are in Company A's file).

Input:

Goal: Output to 2 separate excel files, Company A vs B.

jdminton

Hopefully the macro is included in the package, but this should do what you need. Take a look and mark as a solution if it works for you.

Corp Outputs.yxzp

Output Macro.yxmc

asiu

Amazing! The macro and output works!!

Thank you!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703