Dynamic Select Based on a Multi-Row Formula

Hi,

I'm preparing data for an Excel file. Some of the fields require data, but some are calculated fields. The calculated fields have formulas in Row 2. For my Alteryx preparation workflow, I am trying to dynamically select only those fields where Row 2 is null(). Is that possible?

Thank you in advance,

Dan

Preparation

Accepted answers

BenMoss

I've done a bit of work using Dan S's piece as a starting point, this should take you too where I believe you want to be.

Ben

Dynamic_Filter_Columns.yxmd

All comments

DanS

Hey Dan,

Is something like the attached the direction you were thinking?

If not, could you throw some sample data into a spreadsheet so I could get a better idea of what you're looking for?

Thanks

Dynamic_Filter.yxmd

dprice

Not exactly. I'm looking to select (or deselect, rather) fields if row 2 is populated. The attached is what I'm trying to automate (done manually). In the example, Field 2 and 4 are blank. Those are the only 2 fields I need.

Dynamically Select Example.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703