Dynamic Field Selection

Hi all,

I just stumbled across a solution and thought I would share it. I was trying to select fields based on a a dynamic input, i.e.

required_fields
field1
field2
field3
field4

And my data&colon;

field1; field2; field3; field4; field5; field6 .....
1 ; 2 ; 3 ; 4 ; 5 ; 6 .....

I've produced a macro that uses transposes and dynamic selects/renames to select only the fields that are present in the rows tool. Hopefully it will be helpful to someone in the future!

If anyone has a better way of doing this/has it been done before let me know, I'd be interested to see what else has been done. Or if this is even a problem?

https://gallery.alteryx.com/#!app/Dynamic-Select/56af2b23a248970f909a41d7

Thanks!

Ben - BIPB

Dynamic Select.yxmc

Settings

Macros

Common Use Cases

Dynamic Processing

Preparation

Accepted answers

NeilR

Nice one. Here's an alternative approach...

Dynamic Keep.yxmc

All comments

NeilR

Nice one. Here's an alternative approach...

Dynamic Keep.yxmc

BCarley

Ahh, the Field Info tool! I always forget about that, thank you for your input. Your work flow definitely looks like the right way to do it.

-Ben

scholskjaer

Hello,

without knowing "Dynamic Select" we have built in our team a macro we call "Standardize Structure", I just uploaded it ot the public gallery.

https://gallery.alteryx.com/#!app/Standardize-Structure/58f723def499c713d4206be4

It standardizes the structure of input stream based on provided template. We often use it in combination with our another dynamic macro called "Dynamic Sumarize"

https://gallery.alteryx.com/#!app/Dynamic-Sumarize/58f72349effc2a0dd0bec031

Hope it helps somebody,

Martin

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703