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.

Aligning and Formatting Text

sschong
7 - Meteor

Hi everyone


I have used a PDF tool to extract words out of the PDF, but I have a 2 questions:

 

1. How do I align left on the data fields as per the picture below

sschong_0-1640768632740.png

 

2. What tools are available to automate the exporting of this into a word document? I have tried using the render tool but I have missing data fields which did not really allow me to do so. Any advice? 

7 REPLIES 7
Qiu
20 - Arcturus
20 - Arcturus

@sschong 
For the first question, try to add one Cleasing tool, which would remove the leading and trail spaces.
For the 2nd one, the render tool should do it. can you share your error message?

sschong
7 - Meteor

Hi Qiu, thank you for the reply

 

1. I have managed to do so, but which field do I need to tick to remove the empty data rows under the results page

sschong_0-1640779812120.png

 

2. there is a missing community in the data field, but because the input file is not a structured data and is just images, hence i doubt a data field is required. Is there any other way to bypass this?

 

sschong_1-1640779856599.png

 

nduan
Alteryx
Alteryx

Hi @sschong 

 

For #1, can you try adding a filter with the condition !IsEmpty([Data])

 

For #2, can you try adding a Table tool before your Render tool? 

nduan_0-1640793229848.png

 

 

Then use the Table as your Data Field in the Render tool.

 

nduan_1-1640792807542.png

 

sschong
7 - Meteor

#2 works thanks for your help nduan

 

For #1, will it be like this?

 

sschong_0-1640858863956.png

 

nduan
Alteryx
Alteryx

Almost -- the syntax will be a little different:

 

nduan_0-1640885057969.png

 

sschong
7 - Meteor

Nice! This was very helpful. As for the table that is exported to word, do you know if its possible to remove the table formatting ?

 

tempsnip.png

 

nduan
Alteryx
Alteryx

Yes, you would need to play around with the Default Table Settings (eg. change it so that the Background Color for the Data and Header is white, remove the table borders, etc.).

 

nduan_0-1641500514392.png

nduan_1-1641500694576.png

 

Labels