Hello, can you help me figure out why I am getting different results from a DataPrepStudio Export vs. an Automator Export?
I built a Workspace in Data Prep Studio that selects data from an SQL database and Exports the data to Excel. I included that Workspace in Automator Visual Process.
Issue: When I export from the Workspace in Monarch/DataPrepStudio I get output like this, nulls are removed and numbers are formatted as I specified:

When I run the Visual Process in the Automator using the same version of the same Workspace and the same destination I get output like this:

Thank you for any assistance you can provide!
------------------------------
Clara
Business Analyst
IL
------------------------------