Alteryx Designer Discussions

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

Formatting data inside a table tool

tanvir_khan
8 - Asteroid

Hi all:

 

I'm using a table tool to send summary data on a mail body. I've done formatting for the header. I need to format the last row of the table but can't find any option to do it. Is there anyway to this?

 

Thanks!

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @tanvir_khan 

 

The answer is yes there is, you can use row rule

atcodedog05_0-1621318361917.png

 

Hope this helps 🙂

tanvir_khan
8 - Asteroid

Hi @atcodedog05 

I've seen that option but I couldn't figure out how to get the last row and then apply formatting on that. Can you show me an example if possible? That'd be really helpful.

 

Thanks!

atcodedog05
22 - Nova
22 - Nova

Hi @tanvir_khan 

 

More on how you can implement it is.

 

Workflow:

atcodedog05_0-1621318644933.png

 

1. Use record id tool to set row id

2. Use summarize tool to find max row id and rename it to last row

3. Use appended tool to attach value to the table

4. In table set row rule to check if [RecordID]=[Last Row] if yes set formatting color. You can deselect the record id and last row column since its not needed.

 

Hope this helps 🙂

tanvir_khan
8 - Asteroid
awesome! 🙂
Labels