Dynamic Field Selection

[BCarley]

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:

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

[NeilR · Accepted solution]

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

[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