Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Avoid Alteryx remove leading space when write data into excel

IMSL
7 - Meteor

Hi all,

 

How can I avoid Alteryx remove leading space when write data into excel.

I want to keep the indent.

 

Below is a similar discussion but I am looking for a solution to publish in xlsm not a csv file:

Avoid alteryx remove leading space when write data... - Alteryx Community

1 REPLY 1
FrederikE
13 - Pulsar

Hey @IMSL,

 

This is not something that Alteryx does, but Excel does. Once you open a file leading whitespaces are deleted. 

(You can check this yourself, when you call the file in Alteryx again before you open it in Excel it still has the Whitespace; after it is opened in Excel, it doesn't have it).

 

I am not sure there is a solution (can't find one) - but this would be a question for an Excel forum, Alteryx performs as expected here. 

Labels
Top Solution Authors