Help needed to generate output file in selected font

Question

Hi.

I have an input file (in Poppins font) and after it ran through the Alteryx workflow, the output file generated is in Calibri font.

I have set the Excel Setting (File>Option>When Creating New Workbooks>Default Font Poppins), but this didn't work because the report still came out in Calibri.

I have also seen some Alteryx discussions that suggested the use of Table tool. I've tried this and it didn't generate the desired output file.

Below is the sample input, sample output, Alteryx workflow. The original workflow does not have the Table/Render tool. Once added with Table tool, the output came out totally not in the format that i have originally.

Is there any way for Alteryx to generate the output file in Poppins font?

Please let me know if i'm using it incorrectly in Alteryx Designer. Thank you.

Capture.PNG

Yoshiro_Fujimori · Answer

@tsoochin ,

If you want to keep the format on Excel, you may try BLOB tools as @NicoleJ explaned in her blog:

https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/970280

tsoochin · Answer

Thanks David. Is there any other way to achieve the same result without the Table/Render tool? It'd be great if the font can be changed without altering the output file format actually.

davidskaife · Answer

Hi @tsoochin

If you go down the Table tool route, you'll need to use the Render tool to output the data rather than the Output Data tool. Setting the font in the Table tool then outputs as desired (remember to set font for Headers etc if required, its an option on the screenshot you've shared)