community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

after macro: record created without fields

Asteroid

Hello,

 

I wrote a macro selects a number of fields from a datafile, based on a list of fieldnames.

 

So this data goes in

fieldAfieldBfieldCfieldA
xxxx
xxxx

 

and my second input says

fields
fieldA
fieldB

 

So my macro outputs

fieldAfieldB
xx
xx

 

This goes well, but when I input this macro into my flow then it "thinks" it will cause an error (cf below).

When I run the flow, the macro goes well. The problem is the next step (the dynamic rename, which takes field names from right input rows).

The dynamic rename somehow "forgets" the configuration. I say it should take field x and rename it to field y, but while running the flow, it forgets that it should take field x.

I assume that is because the macro thinks it's outputting 0 fields.

Does anyone know a workaround?

 

issue.PNG

Thanks,

Mikis

Alteryx Certified Partner

Hey @Mikis

 

The macro work when I ran it.

 

Can you send an example that fails?

Asteroid

hi @LordNeilLord

 

please find attached a better example.

 

Every time I run the flow, the rename resets to "variable_type", while it should always be "variable".

Capture.PNG

Asteroid

Just as a sidenote: I know I can fix this by putting this dynamic rename in a macro, and updating the field names (as attached).

i was just really hoping there's a smarter & more elegant fix

Asteroid

Nobody :( ?

Labels