We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Exporting to Template - Formatting Issue for First Row of Data

edmund_belleza
8 - Asteroid

Morning,

 

A few years back I had gotten some help with a workflow problem (see link below)

 

Solved: Splitting Out Template based on Column Value - Alteryx Community

 

I have a follow-up issue. I'm using a similar workflow and template for another project. Field values include text, some are percentages, some are currency ($'s), etc. I have the template set-up with specific formatting. For example, all text fields should be centered, percentage fields should be centered going out to 1 decimal points for some, and no decimal points for others.) When I run the workflow, the text fields in the first row of data are changed to left-justified instead of centered. However, all the other rows have the expected/desired formatting. It's odd that it's just the first row of data.  The Out Data Tool has the "Preserve Formatting on Overwrite (Range Required)) checkbox as checked. I rechecked the formatting within the template, and it has the correct formatting.

 

Not sure why the formatting gets changed by the workflow and only for the first row.  Any suggestions on what may be causing this? or how I may resolve?

3 REPLIES 3
cjaneczko
13 - Pulsar

Ive noticed this on my workflows dumping data into templates as well. For me its more than one row of data, it could be multiple rows. Then everything else below those new rows have the proper formatting. I started noticing it when I upgraded to the newest version of Alteryx. I dont know if its a bug with that, or maybe an excel update that is causing it.

edmund_belleza
8 - Asteroid
Spoiler
 

Thanks for responding. Glad I'm not alone. I'm currently on Alteryx Designer Version: 2021.4.2.47792 and using Excel on Microsoft 365 Apps for enterprise.

Qiu
21 - Polaris
21 - Polaris

@edmund_belleza 
I am running the latest Alteryx Version: 2025.1.2.79 and things getting worse? 😁


SplittingOutAA.png

Labels
Top Solution Authors