Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Adding Text to the end of rows of 1st column from a field or different table for Excel

JKFoil
7 - Meteor

Hello 

Some help please.

I need to put some text derived from the table after the last row on the 1st column.  Either from the same table or another table. Please see mock up example below. I have managed to create the required text with a workflow.

 

Table 1  
Field 1 Field 2Field 3End Calc End Calc
Dave3HappyName-End00000004 Name-End00000004
John4SadName-End00000004  
Paul6SadName-End00000004  
Sue7HappyName-End00000004  
Name-End00000004     

 

2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor

Hi @JKFoil,


You can use union tool to achieve it:

 

Emil_Kos_1-1616493607828.png

 

 

The output:

Emil_Kos_0-1616493602026.png

 

JKFoil
7 - Meteor

Thank you Emil

Worked perfect. I tried this but missed off changing to Auto Config by position.

 

 

Labels