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!

[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 · Accepted solution]

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:

[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...

[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.