incorporation of optional fields in macro

Hi, I 'm working on a macro and trying to incorporate additional fields in the output. I have developed a logic to map 4 additional fields in the macro but, I'm not able map to less than 4 optional fields. Is there any way to map only the field 'ABC' & 'DEF' as optional field 01 & Optional field 02 and keep the remaining 2 fields unmapped? Currently the macro is throwing error If I try to map less than 4 optional fields. Thanks in advance.

test wf_1.yxzp

Macros

Batch Macro

Interface Tools

Accepted answers

MarqueeCrew

@Vivek007ktd ,

when you define the fields in your macro input, name them with (optional) s a suffix.

EmployeeID (optional)

that is the TRYX.

cheers,

mark

All comments

MarqueeCrew

@Vivek007ktd ,

when you define the fields in your macro input, name them with (optional) s a suffix.

EmployeeID (optional)

that is the TRYX.

cheers,

mark

Vivek007ktd

Thanks @MarqueeCrew for the help. It is working

MarqueeCrew

@Vivek007ktd ,

I wonder if that's even documented. I don't recall how I learned it. I'm even more amazed how much I know. But I'm certain that I've forgotten plenty. I don't even recall what I had for breakfast.

cheers,

mark

Vivek007ktd

@MarqueeCrew However your learning helped me to fix an issue in the macro. I can recall what I had from morning till night since I'm following a diet 😁, But difficult to recall alteryx tips and tricks. Documenting such learnings are good for future reference.

PS - I subscribed your channel. Expecting macro development contents in your channel and wishing you all the best 🙂

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703