Delete Null Fields and Rows, Dynamic Rename, Data Cleanse

bsolove

I am using the Alteryx macro to delete null columns and rows.  Then I am renaming the fields (51) with the Dynamic Rename tool to be the first row of data.  Then I have a data clean tool for all fields.  Everytime I run the workflow, the fields I've selected in the data cleanse disappear which causes errors in subsequent functions.

Has anyone seen this happen before?  I am thinking it's due to the large number of fields or something with the macro. 

fmvizcaino

Hi @bsolove ,

One possibility is that your macro is losing the columns configuration and you can prevent that from happening by going to the interface designer of your macro and checking the box 'output fields change based on macro..' as image below.

LEt me know if that works for you.

Best,

Fernando Vizcaino