Multi-Field Selection Using a Macro

I am trying to build a macro that takes two inputs. The first is the main data, and the second is a list of fields to select within the main data (all others should be removed).

Creating a batch macro doesn't work as the output of each batch unions below each other (see attached pics). I am also unable to create an iterative macro as i need to iterate through two input files.

Does anyone have any ideas?

1.png

2.png

Macros

Preparation

Accepted answers

BenMoss

I think you maybe over-complicating this when thinking about batch macros.

Here is how you can achieve this using a standard macro.

Ben

FieldsToKeepMacro.yxmc

All comments

AdamR_AYX

You need a batch macro inside a standard macro and make sure you only pass a single record to the control parameter input of the batch macro.

Take a look at Dynamic Formula in the CReW macros for a very similar example.

BenMoss

I think you maybe over-complicating this when thinking about batch macros.

Here is how you can achieve this using a standard macro.

Ben

FieldsToKeepMacro.yxmc

Koji_B

Hi Ben,

Please would you send me some screenshots.

I am unable to open your workflow as my workplace uses an older version of Alteryx to yourself.

Many Thanks,

Koji

Koji_B

Hi Adam,

Unfortunately the security policy in my workplace does not allow me to download the CREW macros so I am unable to check. Can you send me a screenshot instead?

Best Regards,

Koji

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703