Dynamic number of colmuns in the File Input from a Macro Input Tool

Hey,

when I build a macro and use the Macro Input Tool, I connect the Macro Input Tool with a CSV-File from my directory.

The CSV-File have a saved number of columns.

When I use my build macro a must connect the macro input with a file from the Data Input Tool, that always has the same number of columns as my connected CSV-File in the macro workflow.

Is there a possibility to make the number of columns dynamically withhin the Macro Input Tool?

So can I make a decision only at runtime, how many columns my connected file from the Data Input Tool should have.

Mathias

Macros

Accepted answers

jdunkerley79

Had another play, think you might be able to achieve what you want with something like the attached macro.

Effectively you add missing columns as first step within the macro so all the data you need is there. Only the bare minimum columns get exposed.

Disadvantage is no way to list all fields to input flow

TestMacroDemo.yxmd

All comments

jdunkerley79

If you connect another data source with extra columns they will be passed into the macro.

Assuming you don't need specific fields, I would deselect the field map option on the macro input.

If your output set depends on input make sure you tick box in the interface designer as well.

Have attached a really simple demo just reading out the metadata passed in

TestMacroDemo.yxmd

TestSource.yxmc

mathias_schnoor

Thank you for your support

but your solution works not for that what I mean.

I have attach your an example.

The Macro Input Tool is connect with a CSV-File with four columns.

In the workflow I have only a connect with three column. The macro expected four columns.

So the macro did not work.

Please have a look to my attachment.

mas_dynamic_number_of_inputfields.yxzp

AlexKo

Hi Mathias,

@jdunkerley79 mentioned "Assuming you don't need specific fields, I would deselect the field map option on the macro input."

Just to clarify, I'm attaching a screenshot of where this option is located.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703