Return
-
Title
Automation Export. The output results trims spaces causing the fields to shift. Using regular Export (non Automation), the issue does not happen. -
Description
Open a SQL query file in Editor | run it | right-click the data results | Export Wizard | choose ‘Delimited Text’ | column delimiter is Pipe | save output as text file | open the text file | the spaces in the data looks good and as intended.
Now if the same steps above is done via Automation (open Automation | Export Wizard | load the same SQL query file and choose the same settings as above) | save the Automation | then Run the Automation | open the generated output text file. The spacing in the data is now ‘removed’ or ‘trimmed’ causing the fields to shift. It is trimming the interior spaces causing the fields to shift.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.