Columns deleted after using macros

[aparna0208]

Hi,

I am not familiar with macros but had to use one in my workflow that a colleague had built. It's basically used to normalize address fields like Floor to FL, Avenue to AVE etc. I tried to incorporate that in my workflow but the weird part is when I use that macro, few columns are removed but I didn't touch those fields at all. I'm wondering is this something to do with the new macro that I used? As seen in below snapshot I'm only selecting street address to normalize. The last snapshot indicates how some fields are removed after using the macro. Any thoughts or help would be appreciated. Thank you!

[n8rushton]

My assumption based on what you are describing is that there is a select nested within the macro (second assumption being that this is the checklist you are selecting form) that is saying what fields can pass out of the macro. Macro's by nature require a schema to be very consistent as they enter the macro unless a lot of pre-work is put in to adjust dynamically. With this said, I would first reach out to the creator to see if they would be able to give you a direct easy fix. If not, the community would need the macro and likely a dataset uploaded here to really determine the culprit.

[aparna0208]

@n8rushton yes, that's correct. I reached out to my colleague on this and also I figured out is it's because of the selection of what fields can pass out of the macro. I fixed that and now it's working fine. Thank you for your inputs:)