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

Alteryx Designer Desktop Discussions

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

create new rows with text

SaiJanani
7 - Meteor

Hi,

 

I am trying to add two new rows with text at the bottom of the data

 

Sample Input:

Col ACol BCol CCol DCol E
1123456ABC  
ABC123  Ax*Note 1
DEF187  Bx**Note 2
GHF197  Cx**Note 2
HML321  Dx**Note 2
LKH456  Ex*Note 1
LMB879  Fx*Note 1
     

 

 

Sample Output:

Col ACol BCol CCol DCol E
1123456ABC  
ABC123  Ax*Note 1
DEF187  Bx**Note 2
GHF197  Cx**Note 2
HML321  Dx**Note 2
LKH456  Ex*Note 1
LMB879  Fx*Note 1
     
     
* Share class was launched during the period
** Share class was closed during the period.

 

 

1 REPLY 1
afv2688
16 - Nebula
16 - Nebula

Hello @SaiJanani ,

 

How about adding them with an union tool?

 

Untitled.png

 

Regards

Labels
Top Solution Authors