community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Formula for selecting first row of table on each page in pdf

Meteor

Hi,

 

Is there any rule/formula by which can we modify (for example apply font in red)  first row of table on each page in pdf?

In picture bellow I am looking for way to modify just  rows marked in red:

 

Capture.JPG

 

I am looking for way to do it dynamically (if I don't know how much page rows we have on each page).

Is there way to do it in Alteryx?

Alteryx Certified Partner

Hi @new_user,

 

Within the "Table" tool, you can create a row rule to apply a specific style if the condition is met. See image below...

image.png 

 

In your case, telling it to apply when the row # = 1 sounds just like what you're looking for!

 

Hope this helps!

 

Jimmy

Meteor

Hi  @jrgo,

 

By using Row Rule, I can modify just first row of table.

 

I looking for way for selecting first row of table on each page of pdf (if we have one table on multiple pages in pdf)?

 

 

Alteryx Certified Partner

@new_user,

 

Yes, you're right... that would only work on the first page; my apologies.

 

Here's another option... determine how many records are populating in each page before it breaks and create a formula that will output a value that would attribute the record identifying it as the first row.

image.png 

 

In my example, it was populating 64 records so my MOD expression shows MOD([RecordID], 64). The MOD of 65 (the 65th record) is 1, which is when it know it'll be the first record of the new page.

 

Depending on how many records you determine, you'll adjust this value in the expression. The workflow I attached has a separate Formula tool that shows you what the MOD function is outputting for reference.

 

Attached is the PDF output of this example and the workflow.

 

Hope this helps!

 

Jimmy

Meteor

@jrgo, thank you for your reply!  Is there way to  do it dynamically (if we don't know how many rows we have on each page)?

 

 

Alteryx Certified Partner

@new_user,

 

Glad to help!

 

Short answer, I don't believe so.

 

Bit longer answer... the Render is what splits up your table into pages and it does not have any option to apply additional formatting elements and requires that all formatting be done beforehand. As such, there's no dynamic way (that I can think of at least) to do so.

 

Only option that I can think of would be do do some additional pre-processing of your data so that it groups records which you can use as a "Group By" field in the Table tool.

Labels