Select field that was unselected previosly

mauricio

Hello guys

I'm working with a dataset with aproximately 120 fields. In many situations I have to split the data in two like this:

All fields that were selected in one side, must be deselected in the other side.

Is there any way to perform thys task dinamicaly?

This became a pretty mundane and prone to error task.

Regards!

Common Use Cases

Best Practices

Dynamic Processing

Accepted answers

ArtApa

Hi @mauricio - You may want to explore the Dynamic Select tool: https://help.alteryx.com/current/designer/dynamic-select-tool

For example, you can do the following:

DynamicSelectAA.yxmd

All comments

Luke_C

Hi @mauricio

Is there any criteria being used that dictates which fields get selected? If there's logic the dynamic select tool could potentially help (i.e. select everything starting with ABC). There's a few other things I could think of but without some sample of the data it's tough to say.

apathetichell

Can you transpose the data and filter by [name]? that's usually the obvious solution... Without knowing the format of the column names and the methodology of which fields get selected when - it's a bit hard to say.

ArtApa

Hi @mauricio - You may want to explore the Dynamic Select tool: https://help.alteryx.com/current/designer/dynamic-select-tool

For example, you can do the following:

DynamicSelectAA.yxmd

apathetichell

@ArtApay'know what would make your totally awesome solution even easier... A false anchor from the dynamic select tool... hmm....

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Dynamic-Select-Formula-Mode-False-Anchor/idc-p/773541#M15725

mauricio

@ArtApa, your soluction is not ideal but it is much better than the way I was doing it.

@apathetichell The false anchor in the dynamic select tool would be perfect!

@Luke_C Unfortunately there is not a clear logic to apply to each field.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703