Is it possible to build a macro input with an indeterminate number of columns?

I have a macro set up to process records with an unknown set of columns but I can't figure out how to get the macro to read in a previously unknown set of columns. The macro input tool requires either a file or manual text template, but I need a dynamic template. Is this possible?

Macros

Accepted answers

JordanB

Hi @rpaugh

When configuring the macro input you can add the text input template. Please make sure you leave a field with the asterix in it, as this will allow your unknown set of columns to be processed inside the macro.

Best,

Jordan Barker

Solutions Consultant

All comments

JordanB

Hi @rpaugh

Best,

Jordan Barker

Solutions Consultant

rpaugh

@JordanB, I'm actually already doing that so maybe that's not my problem then.

I've got a detour inside of a batch macro that takes into account record count. If record count is 0 then it assumes an insert is happening and de-selects the ID field from the text template, but continues to pass through any remaining fields (per the '*' method you suggested):

2017-07-31_Alteryx Dynamic Detour Sample.png

However, no records are making it to my data source along the insert path. I did notice that the select tool on that path shows an error since it's relying only on *Unknown fields. Could that be the issue, and if so do you have an idea how to remove the ID field from the text input template and pass the remaining records through to a data source?

Thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703