Avoid alteryx remove leading space when write data into excel

187

Hi guys,

I have data like this 

AAA

BBB

when i use output data tool to write data into excel,

the leading space of BBB will automatically remove by the tool, is there any way i can keep those leading space ?  i want the data keep the same indentation like its original format.

Thanks

pdave87

@187 yes, we can do this as well. Save your output as .csv (without making any changes) and consume .csv output in excel.

I have attached test run (.csv output) for your review. 

Refer screen-prints below:

Regards,

Pratik

2test_Leadingspaces.csv