I have an Excel file with rows of data. For each row, I need to export a PDF letter. All the letters generated from this Excel should be combined in one PDF document (page 1 is letter for row 1, page 2 is letter for row 2, so on and so forth.)
I encountered the following issues, and I'm looking for solutions:
1) Character encoding: The letters are provided in two languages: English (GB) and Chinese (HK). Whilst English texts could be printed successfully, Traditional Chinese characters are not readable as shown below. Is there a way to adjust character encoding in Alteryx? My other PDFs with Traditional Chinese characters work fine (UTF-8, zh-hant, Big5).
2) Text alignment: I'm looking to justify the text. I believe Report Text only has centre, left and right alignments. How do I achieve this (PCXML coding perhaps?)
3) Page layout: I find Alteryx reporting tools still need significant improvement for better report formatting. How do I ensure that pages are divided correctly in Report Text tool? For example, how do I ensure that Page 1 content stays on Page 1 and Page 2 content stays on Page 2?
4) Export to one PDF: How do I export all PDF letters combined? I know the Layout tool has an option for combining records, but for the sake of this project, I must use Visual Layout. How do I do this?