Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Specify Output Excel Cell Format

dlesny
8 - Asteroid

Hi. Is there a way to specify the Excell Output Cell Format?

As defoult it comes out as General but I need it to be Text. The file is picked up by QlikView and if it's General all the '&' couse trouble.

 

Cell Format.PNG

 

2 REPLIES 2
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

@dlesny ,

Someone else may come by and prove me wrong but I believe this is a limitation with the process inherent to writing an Excel file.

That being said, there are other options.

Are you always writing a file in the same format (ie, updating the same data)? You can set up an Excel template and have your workflow point its output to that.

Once you've set the field types you would just need to change the Output Data to append to the existing sheet (if you're writing to .xlsx).

If you're writing to an xls, you can delete the existing and append without changing the field types.

 

Since you mentioned that this is being utilized by Qlik, is there a reason you aren't using QVX files?

dlesny
8 - Asteroid

There was absolutely no reason, other than my little knowledge :)

I have changed to QVX files and after few hours of scratching head, why are my Charts have no data??? ...I got it, It is passing the & correctly.

Excel was clever enough to replace my V_string to numericals for QlikView, and it took me a while before I spot this.

 

 

Thank you for your help.

 

Labels