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!
Solved! Go to Solution.
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.
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.
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:
@ArtApay'know what would make your totally awesome solution even easier... A false anchor from the dynamic select tool... hmm....
@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.